I agree, that is always something to watch for, as using a function on a column in the where or join clause will usually cause a scan plan. In...

I too am not a fan of the NextDay column. In this age of the DATE data type, why not convert SaleDate to DATE and equate it to the...

The posts from peter-757102 and Sean Lange say it all. In a nutshell, this approach will almost always cause index/table scans. Not an issue for a small data...

Very good Grant. Thank you for the reply.

Hello,

Thanks for a great article.

I have a very intermittent problem, occurs only two or three times a month. Would there be any issues with running a server side trace...

I'm not laughing

From Books Online

To pause and resume the default instance of SQL Server

From a command prompt, enter either:

net pause mssqlserver

-or-

net continue mssqlserver

An instance of Microsoft® SQL Server™ can be...