Viewing 15 posts - 20,821 through 20,835 (of 22,232 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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 20, 2008 at 7:31 am
Worth mentioning, did you look at the execution plan?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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?
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 19, 2008 at 8:56 am
The default installation of AdventureWorks is case sensitive.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 19, 2008 at 7:05 am
Oh wow. That is depressing. I'm going to go reread Rendevous with Rama.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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,...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 18, 2008 at 11:52 am
Execution plans changed because of a recompile? That's a pretty likely possibility.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
March 18, 2008 at 11:08 am
Viewing 15 posts - 20,821 through 20,835 (of 22,232 total)