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
space used
2014-01-17 (first published: 2014-01-03)
1,720 reads
Find database file reamaining growth
This script is used for SQL Server 2000 Database file remaining growth. This script is little bit modified to fit SQL Server 2000.
2009-01-14 (first published: 2009-01-03)
1,213 reads
RE: How to Export error log (filter on specific errors) as a job
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
RE: Differnetial Backups applied to different server getting errors
You CANNOT apply a differential without applying a FULL backup.If I understand you correctly, you made a full backup and restored it to a 'backup' server. Now time has gone by and you want to update the information on the backup server; so you made a differential backup and want to apply it to the […]
2004-03-12
RE: log file too big
Tried sp_repldone per the error message you got? Andy http://qa.sqlservercentral.com/columnists/awarren/
2003-06-09
1 reads
RE: copy DTS jobs between servers
Once they're stored in MSDB, this has always sounded to me like an obvious way to do so. I want to copy some DTS jobs from a development server to a production server and I may be forced to use it the way you specified. But what if I somewhat want to document the feature […]
2003-06-03
1 reads
Blogs
Simple Talks Episode 7
By Steve Jones
The season 1, seventh episode of Simple Talks is out. Check it out, with...
A New Word: the McFly effect
By Steve Jones
the McFly Effect – n. the phenomenon of observing your parents interact with people...
Key mappings in Visual Studio Code
At a recent conference I was asked how I executed code during my presentation....
Forums
7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, scheduled book
7 sept, schedlued article
Comments posted to this topic are about the item 7 sept, schedlued article
6 sept, published book
Comments posted to this topic are about the item 6 sept, published book
Question of the Day
Azure Data Lake Storage Gen 2
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers