A clustered index requires more space than a non-clustered index but at most is just one more layer of depth in the B-tree.  This is offset by the fact that...

You can't get a 0 from the query because of the incorrect XML, you would get a parsing error in the SET statement and the query would never run.

Since that...

KH - Have you ever tested your trigger error handling code?

My first experience with writing triggers was in SQL 6.5 or 7.0, and I used code like that (inhierited from...

Manually removing locks in a production database would be extremely hazardous.  If you figured out how to do it you will probably cause massive database corruption.  And if you use...

One reason not to use bit fields in indexes is that they are not very selective, with only two values (three if you count NULL).

If you have a frequently-run query...

You may have an out-of-date BOL.  It is now legal to use bit fields in indexes.

If your database is suddenly doubling in size, but shrinks back to normal with SHRINKDATABASE, it could be because either some process is creating a lot of data temporarily and then deleting it,...

You can run sp_executeSQL remotely.

exec <linkedserver>.master.dbo.sp_executesql N'use <database>; dbcc showcontig (<table&gt with tableresults, all_indexes'

This requires at least ddladmin rights for the linked server login.

I...

Would adding CustomDatabaseRole to db_denydatawriter accomplish the same thing?

Are there secondary indexes on this table?  Dropping the clustered index will cause all other indexes on the table to be dropped and recreated.  This will seriously interfere with access...

SQL will pack bit fields together and allocate another byte only on the 1st, 9th, 17th, ... bit field.

If your bit field is nullable it requires another bit in the...

Why fool around with the differential backups when you've got the transaction log backups?

If you do RESTORE LOG WITH STANDBY= for each transaction log (schedule it to run after the...

You can simplify the query a bit without resorting to checking index status bits.  Every primary key also has an entry in sysobjects:

select

quotename