In this post, I am sharing different scripts on how to find row count, occupied space, free space, page and extent information of the SQL Server Tables. The first step for performance optimization is to measure the size of tables with different information like a number of pages and extents, row size, free space. Below … Continue reading SQL Server: Find the total row count and size of the Tables