2007-09-11 (first published: 2007-05-03)
553 reads
2007-09-11 (first published: 2007-05-03)
553 reads
A simple script to find the database recovery model. Cut & paste into Query Analyser
2007-05-17 (first published: 2007-05-08)
2,958 reads
This simple script (ran from the master database) in Query Analyser removes all the requirements of collating currently connected spids to a database and the need to systematically open a cursor to kill each spid individually by simply placing the database offline, then immediately online.
2007-03-16 (first published: 2007-02-13)
359 reads
If you’re reading this, there’s a good chance you’re straight, white, male, and English-speaking....
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
By Brian Kelley
Through high school and college, I carried deep wounds due to what was going...
I have a stored procedure with the following: SELECT physical_name FROM sys.master_files Where physical_name...
I have the following tables as a example. Table 1 EmpID, LastName, FirstName 1,Smith,John...
I'm doing an update using a self-join, and just want to confirm something. If...