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,610 reads
Scripts
2013-06-13 (first published: 2013-05-30)
3,111 reads
Insert Commas Into Number String
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,430 reads
2013-06-06 (first published: 2009-03-16)
2,643 reads
What got restored from where, by who and when
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,031 reads
Get Rid of All Those Pesky 1 MB File Growth DB Files
Use sp_MSForeEachDB to set all 1 MB file growth databases to 10%.
2013-05-31 (first published: 2012-11-10)
1,461 reads
Search all stored procedures on all databases
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,738 reads
Find Blocked SQL and Blocked By Information.
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,843 reads
To Check for Orphaned Users in a Database
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,691 reads
Search for an object across multiple databases on a server.
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,858 reads
Blogs
Finally Cleaning Up Dropbox: Moving Almost a TB to Google Drive with rclone
By davebem
I’ve had a Dropbox account for years. Like a lot of people, I started...
KDA: Echoes of Deception - Case 4
By Zikato
Someone hacked Digitown's municipality and stole classified documents. 45 million rows of router traffic,...
EightKB 2026 – Schedule and Registration
Hello Hello, We. Are. Back! The schedule for EightKB 2026 Edition has been announced!...
Forums
Displaying Money
Comments posted to this topic are about the item Displaying Money
The Slow Growing Problems
Comments posted to this topic are about the item The Slow Growing Problems
Calculating the Harmonic Mean in Power BI
Comments posted to this topic are about the item Calculating the Harmonic Mean in...
Question of the Day
Displaying Money
I want to get the currency sign displayed with my amount stored in a money type. Does this work?
DECLARE @Amount MONEY; SET @Amount = '?1500'; SELECT CAST( @Amount AS VARCHAR(30)) AS EurosSee possible answers