To see how many VLFs you have solely look at the number of rows returned by DBCC LOGINFO. The size
Doing crash and recovery tests on my local machine I got the SQL Server instance not going online. After trying
Great news, a visual way to manage SQL Server from Linux. SQL Operations Studio came to fill a gap we
SQL Server has many undocumented functions and commands. I will write series of posts with functions to have a library online.
Data types and Precedence of convert types SQL Server associates columns, expressions, variables, and parameters with data types. Data types
Logical Structures How, where, when you need to think in data storage? Well, this is the first step after you modeling
Pages and Extends Architecture The page is the fundamental unit of data storage in SQL Server. An extent is a