Using the KILL command

You can view the status of a KILL command used to stop an open transaction by typing the following:

Views – 950

Expiring Database Backups

The “Backup set will Expire” option is used to indicate how long a backup should be prevented from being over written by another…

PASS 2015 – Seattle WA – Day 3

PASS 2015 10-28-30 Seattle WA SQL Server Indexing for Performance Kimberly Trip NOTE: Narrow NC indexes very rarely are useful. NOTE: Putting a…

Using the DAC (Dedicated Admin Connection) in SQL Server

From Kendra’s blog: There’s always a catch. You many need to get firewall ports opened as well, depending on your environment and…