Viewing 15 posts - 20,791 through 20,805 (of 22,202 total)
sqluser (3/20/2008)
But i need to do the same for all the table columns having uniqueidentifier.---
The first query will show you all tables and all columns with uniqueidentifiers. You'll then...
March 20, 2008 at 8:03 am
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...
March 20, 2008 at 7:31 am
Worth mentioning, did you look at the execution plan?
March 20, 2008 at 7:24 am
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,...
March 20, 2008 at 7:12 am
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...
March 20, 2008 at 6:58 am
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...
March 20, 2008 at 5:44 am
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...
March 19, 2008 at 11:28 am
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?
March 19, 2008 at 10:43 am
jburkman (3/19/2008)
I've read this excellent thread, I see the vibrant knowledge and experience of the participants, and I'm de-lurking to...
March 19, 2008 at 8:56 am
The default installation of AdventureWorks is case sensitive.
March 19, 2008 at 7:05 am
Oh wow. That is depressing. I'm going to go reread Rendevous with Rama.
March 19, 2008 at 6:56 am
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...
March 19, 2008 at 6:51 am
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,...
March 18, 2008 at 12:00 pm
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.
March 18, 2008 at 11:52 am
Execution plans changed because of a recompile? That's a pretty likely possibility.
March 18, 2008 at 11:08 am
Viewing 15 posts - 20,791 through 20,805 (of 22,202 total)