Hey, I lead a pack of Cub Scouts. I'm responsible for teaching them the "Fart Song."

[to the tune "The Yellow Rose of Texas"]

Oh, my body has a passage that...

Whoa! Hold on. Revelation! People who come out of college are mature adults? Hmmm... To ask this in the proper SSC manner, you have a test that proves that?

jburkman (3/19/2008)

---

Post #1, so I'll try to make it a good 'un.

I've read this excellent thread, I see the vibrant knowledge and experience of the participants, and I'm de-lurking to...

The default installation of AdventureWorks is case sensitive.

Oh wow. That is depressing. I'm going to go reread Rendevous with Rama.

I tried it two ways. I set up a table with a million rows for the tests.

This way works very well, with a nice index seek and only four...

Crud. I completely misread your question. Disregard my last post. I'm an idiot.

Why can't you simply do a join against your table? Especially since we're talking about a distinct list,...

2005 Plan cache is pretty radically different than 2000.

Take a look at at this blog by some of the developers from MS. It might help.

Execution plans changed because of a recompile? That's a pretty likely possibility.

Take a look at the OUTPUT clause as a mechanism to capture the data that is inserted as it gets inserted. This is much more effecient, as well as easier...

If you want it to go into a temp table, this works fine (I used Adventureworks to test it):

SELECT ContactTypeID, [Name] INTO #mytem FROM Person.ContactType

union

SELECT StateProvinceID AS CultureID, [Name] FROM...

If you're getting multiple values from one table, you should probably apply some type of filter either in the ON statement of the join or in the WHERE clause. You...

After it gets applied, any impact is dependent on the number of rows inserted or updated against which an assertion for this constraint must be made. The more rows immediately...

Just that when you set up a linked server its available to every database and every user (that has the password, assuming you don't cache it in the connection, making...

Steve Jones - Editor (3/17/2008)

---

Speaking of lunch....

I once got a resume with the "Interests" section saying "Eating exotic meats"

I wanted to bring the guy in just to see him, but...