2016-07-04 (first published: 2016-06-08)
763 reads
Table Size
Calculate Table Size and row count
This script calculates table row count and size(MB), as well as the used space and free space.
2014-01-31 (first published: 2014-01-17)
1,921 reads
Easily calculate the size of your tables
This quick and dirty sql will tell you the number of rows in your tables, the size in MB of yout data, and the total size (including indexes)
2009-05-04 (first published: 2008-10-04)
1,631 reads
Tables, Queues, and Indices as a Percent of DB Size
Two views that give you a variety of stats, sortable as a percent of DB size, for tables, indiceses, XML indices, and Service Broker Queues.
2012-10-09 (first published: 2008-06-16)
3,034 reads
Blogs
Why do DBAs dislike loops?
If you started out as a developer you were probably taught how important loops...
Public and Demo Data Coming Soon!
Any database professional that has been around the Microsoft world for more than about...
New Centralized View of SQL Resources in Azure
Yesterday, some new views were made available in the Azure portal that will be...
Forums
Upgrade to SQL Server 2008 R2 SP2 from SQL Server 2005 SP3
Hello, I noticed that SQL Server 2005 SP3 is not in the in the...
Can't drop database in "restoring" state from secondary instance of AG
MSSQL version: 2016 (13.0.5026.0) Situation: Removed a database from an availability group so it...
ReportServer Database upgrade fails
I've tried several times to successfully migrate a SQL Server 2008R2 ReportServer and ReportServerTempDB...
Ask SSC