sp_spaceused Archives - SQLServerGeeks

SQL Server sp_spaceused returns wrong count

October 3, 2012December 23, 2019 - by SQL Geek - 7 Comments.

Today, I came across a surprising situation when running sp_spaceused on one of my dummy table “Tblemployee”. The SQL Server sp_spaceused told me that it has over 200,000 records, however it …

SQL Server – Get TOP 5 Tables Consuming Maximum Space

January 2, 2012November 28, 2014 - by Ritesh Medhe - 6 Comments.

I always say that database sizing is one of the prime tasks and concern for any DBA. As a DBA you should ensure that there is no single record claiming space …

SQL Server: SQL-Getting rid of unused space in table

December 24, 2011August 28, 2014 - by Ritesh Medhe - 6 Comments.

Scenario: Database sizing is one of the most critical tasks for any DBA. One of the DBA’s tasks is to also ensure optimum performance. Database/table size is one of the key …