Monthly Archives: March 2008

Table Size Query

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