Table Space Used in DB
A quick script that provides the sizes of the tables in your database, including schema and choice of sort method
2018-08-07 (first published: 2018-07-29)
808 reads
A quick script that provides the sizes of the tables in your database, including schema and choice of sort method
2018-08-07 (first published: 2018-07-29)
808 reads
This script uses a cursor to loop through all tables and get the count and table sizes using sp_spaceused. It is much faster and efficient than use 'SELECT COUNT(*) FROM TABLE_NAME'.
2012-06-22 (first published: 2012-06-09)
1,988 reads
2009-03-04 (first published: 2009-02-16)
1,267 reads
A better way to use sp_spaceused, returning values on one row for the database instead of two.
2008-09-04
4,073 reads
By Vinay Thakur
This blog series on Audit/Compliance/Security, this is first blog where we would discuss about...
In the previous post, we've built a SQL Server 2025 sandbox in an OrbStack...
By Steve Jones
Thanks to everyone for attending my talk today at Day of data Baton Rouge...
Yeah, I know this is a 2022 forum, but I don't see a 2025...
I don't see a PowerBI forum, so I'm posting here. I have a need...
Comments posted to this topic are about the item SQL Server Certificates
If I use the -k parameter with a number after it, what does this change in SQL Server?
See possible answers