Every table in SQL Server contains at least one partition (default partition) even if the table is not explicitly partitioned. -- The T-SQL query below uses the sys.partitions catalog view to capture ...

This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.

Many times when we manage sql server databases we need to determine how much space each table is consuming on disk. in this blog we will learn two approaches for solving this frequently encountered ...