The biggest ones I've seen:

- not indicating a primary key and an identity column

- not explicitly creating foreign keys between tables - just relying on the application to handle the...

Nice Steve! The only redemption I have is that I read it first before trying it one step at a time...so at least I saw the April Fool's first...

Very funny guys...

Thanks guys - just the thread that I needed!

I applied KB954606 to our Dev server with success; then applied the 64 bit patch to our production server with equal success.

Thanks...

We have a 2005 cluster, and two standalone 2005 boxes for reporting, as well as a few 2000 boxes. All are enterprise version. The 2005 boxes do not seem to...

Raj - thanks for the info. Seems pretty straightforward.

I'm a big fan of using some type of VM for taking a production environment to use in a development environment. That way, there would be up to date data...

One more tool to look into. I certainly like the dashboard for a quick view of the overall health of all of the servers... Thanks for the article.

I found similar results to the previous poster regarding the use of VarChar vs. NVarChar (for those of us without having to support multiple platforms...).

In my results - varchar ended...

I ended up starting a MS in Computer Science once I got into the field. The cost/benefit analysis was a moot point - the company I worked for paid for...

Seems to me that it is working exactly as expected. If you define a parameter to be a certain length, then that should be what you get. I do understand...

I know there's a for fee version available, but there also used to be a free version of SQL Prompt from RedGate (not sure if there still is...). It's great...

As with most other folks, I didn't see anything pertaining to SQL 2005, so assumed that it applied to any version of SQL Server...and subsequently got it wrong! Oh well...