Not this exactly, but Andy had some queries that would run fine for weeks and then all of a sudden start grabbing different query plans.

I suspect that you have some...

Don't use !=, it can cause issues. Use IS NULL or IS NOT NULL

You might need to burn the $249 and call PSS. I'd bet that the driver is flaking somehow. We got some strange results from DB2 with the Client Access driver...

You can run Profiler and watch for queries when the tempdb is growing. If this is a function of the data increasing (larger results in queries) then there's not much...

Need to find out why tempdb is growing so much. What is happening in your code that is causing tempdb to jump.

Used to play rugby myself in college. One torn shoulder later I just watch my 7 year old in flag football. Looking forward to him hitting people next year.

Living in...

Might have been "More?" a few years ago. After 3 kids, it's probably "one, two floor"

Havne't looked at the Maint Plans, but that's something to check out.

Ah, perhaps I did miss the point of the exam, which would explain some things. I am still disappointed that I think a good test taker could pass most of...

Anytime we can help the beer industry, we will aspire to do so!

We need a study on Tequila lengthening your lifeline or something like that. Shot and a beer, the way to go!

Sameer has great advice.

Looks like 8GB for SS2K (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_8dbn.asp)

2005 is limited by Windows (http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx) and W2K Ent is 8GB, W2K3 Ent is 1TB on 64-bit (http://www.microsoft.com/windowsserver2003/64bit/x64/enterprise.mspx)

Wow, used to be a D&D'er back in the early eightys and loved it. Tried to get my 13 year old interested a couple years ago, but it wasn't "cool"....