How Long Backups Will Take
When you are running a backup or a restore, this script gives you an estimate of completion time.
2013-06-14 (first published: 2013-05-30)
1,563 reads
When you are running a backup or a restore, this script gives you an estimate of completion time.
2013-06-14 (first published: 2013-05-30)
1,563 reads
2013-06-13 (first published: 2013-05-30)
1,861 reads
Function to take a number as a string and return it with commas separating thousands, millions, etc.
2013-06-07 (first published: 2009-03-31)
2,325 reads
2013-06-06 (first published: 2009-03-16)
2,596 reads
Ever wondered what got restored, who did the restore and where the backup came from that did the restore?
2013-06-04 (first published: 2012-08-23)
2,006 reads
Use sp_MSForeEachDB to set all 1 MB file growth databases to 10%.
2013-05-31 (first published: 2012-11-10)
1,423 reads
Need to find every stored procedure in any database that references the table FooBar? Here is a quick and easy search to do that.
2013-05-30 (first published: 2013-05-22)
1,595 reads
This is a stored procedure which can be used to find which processes are been blocked by each other. This Procedure will also provide SQL information associated with the blocked SPID.
2013-05-23 (first published: 2009-06-15)
2,780 reads
This script is helpful to identify the orphaned users in a database, useful when we restore a database from a different location.
2013-05-22 (first published: 2008-07-20)
2,604 reads
There are other options available like Sql search from Red Gate. Here's a simple script to search for objects(s) containing a particular keyword.
2013-05-21 (first published: 2012-08-23)
2,818 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