2016-04-01 (first published: 2016-03-23)
830 reads
2016-04-01 (first published: 2016-03-23)
830 reads
2015-12-25 (first published: 2015-12-17)
1,667 reads
2015-10-09 (first published: 2014-03-21)
4,768 reads
This script will check if the SQL Server you are connected to is actually running.
2015-04-01 (first published: 2015-03-27)
1,708 reads
Old version, archived, that works on ss2k. Updated version works on ss2k5. NOTE: This is a Microsoft developed script, not from the contributor (Steve Jones)
2007-06-27 (first published: 2006-05-04)
877 reads
A script that will help you deal with and get through any disaster recovery situation.
2005-04-01 (first published: 2005-03-29)
522 reads
This stored procedure performs a full backup on all databases on a server. It takes a parameter for a drive letter and will create the backup structure as needed. The standard backup structure is "\mssql\backup\".
2001-10-22
539 reads
Ever wanted to get rid of users who are sitting idle for long periods of time? Here's a script that removes spids idle for a variable period of time.
2001-10-03
4,455 reads
This script runs within a DTS package. It searches the backup directory stored as a global variable in the script and trims all backup files older than some number of days. the script includes logging to the C: drive so you can trace the effects of the script. You need to create the global variables […]
2001-09-12
1,467 reads
This script will search all logged in users and return the spid along with the number of seconds since that spids last batch was executed.
2001-08-22
914 reads
By Steve Jones
I had a great time at Techorama. I’ll do a writeup on the event,...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
It seems that none of the cloud providers have internal load balancers that can...
Hi guys, I hope someone of you has the time to help me. I...
Comments posted to this topic are about the item The 2022 Preview