Get SQL Server Row Count and Space Used with the sp_rows
Check out this stored procedure sp_rows to get a listing of space used and rows counts for your SQL Server database tables.
2018-10-10
3,405 reads
Check out this stored procedure sp_rows to get a listing of space used and rows counts for your SQL Server database tables.
2018-10-10
3,405 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)
725 reads
Dattatrey Sindol explains the different ways in which you can get the row counts from all the tables in a SQL Server database.
2017-06-22
5,549 reads
If you want to find TotalPages, Usedpages,datapages,totalspaceMB,UsedSpaceMB,DataSpaceMB then can use this query.
2019-05-03 (first published: 2014-12-26)
1,448 reads
2014-04-24 (first published: 2014-04-05)
1,961 reads
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,959 reads
2014-01-17 (first published: 2014-01-03)
1,720 reads
Use sysindexes\DMVs insead of select count(*) to retreive table row counts
2011-01-28 (first published: 2009-09-02)
55,574 reads
2008-01-24
1,125 reads
Try on code similar like thisCREATE TABLE #errors (errorlog varchar(255), continuationrow int) INSERT #errors (errorlog, continuationrow) EXEC xp_readerrorlog SELECT errorlog FROM #errors WHERE errorlog LIKE '%Login failed%' DROP TABLE #errors
2005-04-29
3 reads
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
At a recent conference I was asked how I executed code during my presentation....
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers