I promise I won't be upset. So, now you can...

It made him take a short vacation in a desert. (I generally prefer a vacation with dessert over a vacation in the desert, but that seems to be his...

bpatin (11/19/2009)

---

I've seen the T-SQL for a maintenance plan (view only) with a disclaimer that it may not be exactly what the server will be executing, but see no way...

Steve Jones - Editor (11/19/2009)

---

I struggle with this a little. I want to allow people in the community to interact, which includes vendors. At the same time, Red Gate does...

Easy enough to have a trace that grabs the host data for the connection, and then dump that into a table for analysis.

Would probably want to use events 14 and...

Steve Jones - Editor (11/19/2009)

---

I think the problem with many of the "considerations" or "rules" that GQSquared listed is that they don't mean anything if you're ignorant. What is "appropriate"...

Paul White (11/19/2009)

---

You're probably right - it's just he/she...

If I'm correctly understanding the design, yes, you should use cursors for that. It's what's known as a "one true lookup table" solution, and it's a complete violation of...

It's spam. You should care.

Roses are red

Violets are blue

I'm not a poet

And you aren't either

You still haven't posted the non-SQL relational solution to the problem that you posed.

I looked at the sample "true relational" databases you posted earlier. They are only "true relational"...

Brandie Tarvin (11/18/2009)

---

Sorry, GSquared. I have an anti-ditto (of a sort) to your list.

RE: Indexing. Yes, index. But don't OVER index.

Pet Peeve = developers add an index to an existing...

jcrawf02 (11/18/2009)

---

... which prompted me to Google LASHIWAB, which results lead to my next question... should answers on ask.sqlservercentral.com be scored higher if they were given in rhyme rather than...

john scott miller (11/18/2009)

---

I don' treally care weather it comes back different between using nolock or not, i just enjoy finding inconisencies in the system and finding out why these...

David Portas (11/18/2009)

---

GSquared (11/18/2009)

---

SQL will, I'm sure, go the route of the buggy whip one day. But the replacement technology hasn't, to my knowledge, been invented yet. I...