The idea was taken from this script: http://www.sqlservercentral.com/scripts/Maintenance+and+Management/61448/
Which did not work in SQL 2005 due to table changes on MSDB
2013-05-08 (first published: 2008-02-12)
5,585 reads
This script uses the backup tables to get info on the growth of your database files.
2013-05-07 (first published: 2009-02-03)
15,185 reads
Use this and shrunk a 176GB in under 20 secs to 105 MB. Ensure that you understand the potential issues with the recovery of your database.
2013-05-06 (first published: 2008-07-21)
14,006 reads
Query Active Directory Computer objects to verify existence
2013-05-01 (first published: 2013-04-16)
1,129 reads
Pre-Create Active Directory Virtual Computer objects to support a new SQL Cluster
2013-04-30 (first published: 2013-04-15)
1,010 reads
Changes DB owner to sa for Online DB's where owner is not sa
2013-04-26 (first published: 2013-04-12)
2,773 reads
A while ago I once attended an interview where I was asked to write a short script that counts each letter of a given string.
2013-04-25 (first published: 2013-04-12)
1,698 reads
This function can convert a Arabian number to english,for example,if you input 1234.56, then you'll get 'One thousand two hundred thirty four and cents fifty six'.
2013-04-22 (first published: 2002-08-08)
548 reads
2013-04-18 (first published: 2013-04-05)
1,472 reads
Reursive CTE Script to generate n numbers
2013-04-17 (first published: 2013-04-03)
1,494 reads