Monthly Archives: March 2008

Table Size Query

Posted on March 8, 2008 by Clay Lenhart

The following query lists the tables and the space they use. This query is much faster (sub-second) than a standard SELECT COUNT(*) query since it uses the dynamic management views in SQL Server rather than scanning your data. SELECT sum … Continue reading →

Posted in SQL Server Administration | Tagged , | 16 Comments