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)
771 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)
771 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,961 reads
2009-03-04 (first published: 2009-02-16)
1,247 reads
A better way to use sp_spaceused, returning values on one row for the database instead of two.
2008-09-04
4,039 reads
By Steve Jones
As I’ve aged, I find myself struggling to read many things in my life....
For this month’s #PGSQLPhriday 014 blogging event, Pavlo Golub has asked a pretty simple...
By Kevin3NF
In SQL Server, the terms “set-based” and “row-based” refer to different approaches or styles...
Hello everyone, I am rather new to SQL-Server and got a problem to which...
Hello, I want to have value Month ago Year ago So far, I've this...
Comments posted to this topic are about the item The Fake Speakers