Here's a sample script to help you get some generic mode, median, and mean statistics for something. In my example, I'm getting the number of days something takes to start and stop some task. The idea is that I'd have a fairly short list of jobs, and record would record the job id, and start/stop […]
2006-08-17 (first published: 2006-08-02)
1,051 reads
This script will create a single-line ALTER TABLE statement for each column in any table to change the collation to match the 'database default'. This is best accomplished in the Query Analyzer -- simply run the script, select all the records, and paste them into a new window to run them.
2005-12-29 (first published: 2005-12-12)
2,045 reads
This script creates a stored proc that was intended to run from a trigger on the master..sysdatabases for each database creation. Alas. It will create three jobs for each database you apply it to. First, it'll create a job to run a full backup each Sun, at 5am (see below). Those backups will be retained […]
2004-12-16 (first published: 2004-11-11)
372 reads
Full documentation on the Undercover Catalogue can be found HERE We’ve spotted a bug in...
By Steve Jones
With my new laptop, one of the things I realized I’d forgotten to do...
By Steve Jones
This month we have a good invitation from Deepthi Goguri, where she asks us...
Comments posted to this topic are about the item GIT Configuration and Automated Release...
Comments posted to this topic are about the item How to Add a New...
Hello All, We have a domain account running sqlserver service.this account has r/w access...
Which server role(s) can set a database to the Emergency State?
See possible answers