Thanks Jeff. I should have figured that one out, but then I only worked for a Conference Call company for 2 months (contract job) before getting the position I...

It could just be me, but the world is full of acronyms especially TLA's. What is CDR? Not the code, the acronym.

As I am not commuting between Colorado Springs and Denver anymore (did that for 15 years), most of my driving today is city based, so the hybrid would be useful...

The hybrids aren't necessarily that great. I had a 1990 Ford Fiestiva (4 cylinder engine) that got 50 mpg. I also had a 1993 Honda Civic (4 cylinder...

NEI (Not Enough Information). What differences are you looking for between the tables. To help you, we really need to have the DDL for your tables, some sample...

Jeff Moden (11/27/2007)

---

Jason Selburg (11/27/2007)

---

Lynn Pettis (11/27/2007)

---

Actually, more than read the article, take it to heart and follow its example! You know what they say about leading a horse...

Actually, more than read the article, take it to heart and follow its example! You know what they say about leading a horse to water...

😎

Maybe, but I also think it is a valid question. If asked for help in SQL 2005, why would I write something that would also work in SQL 2000...

Jeff,

Same here actually, but I'd work on one with test data in tabular format before one that has no test data at all.

I also go for the ones with "this...

My question to you is this, why are you looking at SQL 2005 solutions in SQL 2000? This doesn't make sense to me. If a person is using...

Having the test data in a ready to use format is great, but even if they provide it in a tabular format, it is better than nothing. I use...

Very good article Jeff. Unfortuately, as others have mentioned, those who really need to read it won't, and if they do, they probably will ignore the advice.

😎

Looks like a missing comma (,) after OtherTotal.

Which one you use (Simple or Full recovery mode) depends on your restore requirements. Using simple recovery mode, you can only complete full or differential backups. Using the...

Except for maintenance plans, yes you need to use BIDS. BIDS is nothing more than Visual Studio, and yes it is on the installation disks for SQL Server 2005.

And...