Script to get the tables size in SQL Server
A simple script to know how much space the tables are taking from the disk. SELECT t.name AS TableName ,
Category: storage
Don’t shrink the trees
The most common and widely used index that we know are nonclustered index. These indexes are created using the famous
Data types
Data types and Precedence of convert types SQL Server associates columns, expressions, variables, and parameters with data types. Data types
Storage – Part II
Logical Structures How, where, when you need to think in data storage? Well, this is the first step after you modeling
Storage – Part I
Pages and Extends Architecture The page is the fundamental unit of data storage in SQL Server. An extent is a
