Idle Spid Time
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
1,027 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
1,027 reads
Lumigent has updated their transaction log analysis tool to include a number of features that every DBA will find handy. Read this review of a great new product.
2001-08-22
6,352 reads
2001-08-20
3,501 reads
Ever need to recover a single package? Don't have local backups? Read this!!!
2001-08-16
6,896 reads
2001-08-13
4,082 reads
DBAs often ask how to transfer DTS packages and move them between servers. They also want a version control system that is more robust than that provided in msdb. Steve Jones looks at one of the features of the DTS designer that solves both of these problems.
2001-08-09
5,996 reads
2001-08-08
2,619 reads
This procedure will BCP out all data in a table. The format is designed to be used with the dbsp_bcp_in stored procedure to import the data back into a server.
2001-08-08
3,967 reads
This is a great administrative reference for anyone using SQL Server 2000.
2001-08-08
3,312 reads
I got this script from SQL Server Professional Magazine in an article by Andrew Zanevsky. It performs transactions to fill up virtual log files and continually shrinks the log until the desired level of shrinkage is achieved.
2001-08-08
10,201 reads
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
The STIG is detailed, which is a good thing, but I found myself wanting...
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
I have about 100 Tables that are all suffixed with _Modify. These tables record...
Comments posted to this topic are about the item Make It Routine
Comments posted to this topic are about the item Finding Gaps in Sequential Data...
If I want to know whether a number of negative, positive, or zero, what is the easiest way to get this in T-SQL?
See possible answers