Great Answers to
Questions About Everything

Why Would Someone Put `where 1=1` in a Query?

Sql Server Database in recovery: How to Stop, Take Ofline or Delete?

Create View in Specified Database with Dynamic Sql?

Does Firing off an Indefinite WAITFOR Increase the Log File Size?

Turning OFF CHECK_POLICY by Default

How Do I Copy a Table with SELECT INTO but Ignore the IDENTITY Property?

Do You Know an Easy Way to Generate One Record for Each Hour of the past 12 Hours?

SQL Server 2005/8 Query Optimisation Hints

Different Results Rebuilding an Index Online & Offline

Query Performance Degrades with Time & Use