Take a look at these.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;289209

http://support.microsoft.com/default.aspx?scid=kb;en-us;272568

http://support.microsoft.com/default.aspx?kbid=296265

http://support.microsoft.com/default.aspx?scid=kb;en-us;822219

I agree the assumption of a specific value is incorrect if you need to support the unknown. FOr example we have a system which has schedules that become active at...

Already been done here http://www.sqlservercentral.com/columnists/jtravis/understandingthedifferencebetweenisnull.asp

Access is a single threaded application envrionment and can cause flickering quite often when a lot of updates occurr on the screen as it draws each change. This is most...

This is the strangest trigger I have ever seen. I don't think I won't to update anything and if you have a multi nesting situation when it reaches the maximum...

Also note you can do assignments like so.

update tblName set @var = col = col + 1

Which means you can read and write the data at the same time. This will help prevent...

After further thought and reviewing your code I realized you left one area out that should be addressed.

You check to make sure password and login don't match but you should...

Don't forget sp_change_user_login

Oops, guess I need some more caffein this morn. Up 4 times last night with the baby and not reading straight. Thanks

"You are trying to audit your SQL Servers to determine what version they are on.

To do this, you're looking for a method to tell the version number of your...

Great job but I do suggest you try it after you change to the following to clean out the caches.

dbcc dropcleanbuffers

DBCC FREEPROCCACHE

I tested on a system with 1 Million rows...

"Only close the connection and do not set to NOTHING if the site is going to be used frequently. The reason is when you set the object to nothing it...

Oh should also backtrack here and say the between should be for that case because you only have to evaluate the date range start and end one time each so...

In your case of writing once a day you will see more action in the tempdb than in the logs. So yes tempdb is priority here. Selects are not logged...

I have found that you need to make sure the buffers are cleared or run mutiple times to see which is truely faster. Consider which you ran first and the...