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)
736 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)
736 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,955 reads
2009-03-04 (first published: 2009-02-16)
1,245 reads
A better way to use sp_spaceused, returning values on one row for the database instead of two.
2008-09-04
4,038 reads
By Chris Yates
Data continues to be the lifeline for companies across the globe. As maturity levels...
By Steve Jones
Today’s coping tip is to get outside and notice how the weather feels. This...
By SQLBalls
Hello Dear Reader! What an incredible week we had. I started off traveling on...
Hello! Backups are automated for Azure SQL Prod environment, we can do point-in-time recovery...
Hi all, I am running the following query in SQL, trying to export some...
Please suggest practice on SQL Server RLS On the database level, defined users with...