First off it is a very good article and pointed out something I never noticed before.

But I do agree with Chris.

Only when the name of the executing SP was...

This was written for Eastern Time Zone and does take into account the diff between ST and DST

CREATE PROCEDURE Convrt_GMT_To_Eastern

@DateIn datetime,

@DateOut datetime OUTPUT

AS

--This Code Converts GMT to Local Time

Declare @DateUse...

Can you post your current DDL for both tables. I need to understand what you have. For me I have a column for last modified by and a last modified...

And I almost ought a 60 inch recently. Guess I will just wait a bit longer for the 32 foot models and charge admission.

You might want to explore differential backups or if you have some tables for say historical purposes and some for the live transaction consider a file group stratagey where you...

Beyond the previous I suggest look in the Windows Event Viewers logs to see if anything unusal. Could also be a network setting at either NIC or somewhere in between....

There was a really good discussion on this about 4months to a year ago. Sorry do not have the link right off.

I have done it on a live server before but as mentioned the files are in an open state unless you have the auto close feature on (which I don't...

Yes you should consider your wording very cerfully. However that said what software are you referring to? If SQL Server the evaulation is 120 days not 30. And it is...

Let's just say, it all depends. Look at the execution plan and test both. Sometimes one way works best, sometimes the other.

First I can guarantee the Server will outperform the desktop overall. But it could be factors of the cahce being populated already, distance data travels across network, network bandwidth. Try...

Watch the server with Profiler and see what is coming in for the SQL statement. May be something you haven't accounted for that revolves around the way you are doing...

I don't know a specific limitation in the IN clause but I can tell you there is a point a really long typed IN list will actually hurt performance. I...

When you day it crashed what are you meaning. Was it an OS failure, hardware, other?

First off TempDB is used in a lot of operations as a scratch pad so never assume it is not being used by your statement.

From the statement it sounds like...