SQL Server Education (by the geeks, for the geeks)
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 sp_spaceused returns wrong count Read MoreI 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 – Get TOP 5 Tables Consuming Maximum Space Read MoreScenario: 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 …
SQL Server: SQL-Getting rid of unused space in table Read More