The first query will show you all tables and all columns with uniqueidentifiers. You'll then...

Since there are likely to be more wars (unfortunately) why not set up a table of wars with the appropriate date ranges and then join against it? That way you...

Worth mentioning, did you look at the execution plan?

First off, if these are primary keys and you have referential integrity, you have a MAJOR task in front of you. Why would you want to do something like this?

Otherwise,...

I would add to the Administrative costs a very high cost to implement changes. Tune one procedure, deploy it 200 times. Modify one column, rebuild 200 tables in 200 databases...[shudder]

I...

I wouldn't have expected all those cache misses (miss's?) either. What did the test procedure do? Take a look at the link posted above to see if the test proc...

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.