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)
790 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)
790 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,969 reads
2009-03-04 (first published: 2009-02-16)
1,254 reads
A better way to use sp_spaceused, returning values on one row for the database instead of two.
2008-09-04
4,044 reads
By Zikato
I’ll walk through the KDA UI and tackle the first challenge before diving into...
By Zikato
While I mostly write about SQL Server, I have a soft spot for Kusto....
By Steve Jones
Many organizations list customer testimonials and quotes on their websites or literature. It makes...
Hi Guys, I'm not sure if this is possible or not, but let me...
Comments posted to this topic are about the item Life Moves Pretty Fast
Hello SSC, Happy Friday! I have to optimize a process that uses dynamic SQL...
Can I have a collation expression like this in SQL Server 2022?
... WHERE ColumnA = ( 'abc' COLLATE French_CI_AS) COLLATE French_CS_AS ...See possible answers