In many cases, you can resolve deadlocks by setting the database to read_committed_snaphot as the default isolation level.

ALTER DATABASE [MyDatabase] SET ALLOW_SNAPSHOT_ISOLATION ON;

ALTER DATABASE [MyDatabase] SET READ_COMMITTED_SNAPSHOT ON;

Using Row Versioning-based...

Just build the cluster with a new name. In a true disaster recovery, you can rename the cluster using the procedure below.

How to: Rename a SQL Server Failover Cluster...

You could do this:

1. Create another admin login and use that one, so that it won’t matter if the SA login is locked out.

2. Change the name of the SA...

How to Connect to a SQL 2005 Server When You Are Completely Locked Out

http://www.sqlservercentral.com/Forums/Topic812701-471-1.aspx

It is really a business decision on the part of Microsoft not to spend the resources to add a feature that will only rarely be needed.

If there is really a...

It is likely that the select queries are timing out because of blocks by the deletes. You should consider setting the database to read committted snapshot to prevent deletes...

san43 (1/11/2010)

---

I have scheduled a full backup after the rebuild index job, so that I don't get a huge transaction log backup. But a transaction log after the full backup...

Just convert the DATETIME value to datatype DATE.

select

MyDate = convert(date,MyDateTime),

MyDateTime

from

( -- Test Data

Select MyDateTime = getdate()union all

select dateadd(hh,-11,getdate())union all

select dateadd(hh, 11,getdate())union all

select dateadd(hh, 12,getdate())

) a

Results:

MyDate MyDateTime

----------...

select

HoursWorked =

right('0000000000'+convert(varchar(10),convert(int,a.HoursWorked*100)),6)

from

( -- Test Data

select HoursWorked = 2080.00 union all

select HoursWorked = 780.50

) a

Results:

HoursWorked

-----------

208000

078050

Script to analyze table space usage:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=61762

I often schedule a job to run sp_updatestats on each non-system database on a daily basis.

This procedure was greatly improved with SQL 2005 to only do updates when they are...

I test all drives with 8KB, 16KB, 32KB, 64KB, 128KB and 256KB block sizes for sequential read, sequential write, random read, and random write for a total of 24 tests...

maria_gallagher (11/29/2009)

---

Hi Michael,

The script worked great. It's very detailed!

Is there a way to stop rounding of the File_size_used and file_size_unused values? Currently it may display 7606, while in Taskpad view...

This script gets the file information for every database on a server, inserts it into temp table, and queries it multiple ways to give various levels of analysis of file...

If the table you are selecting into will later have a clustered index created on it, it is usually faster to create the table first and insert the data in...