Viewing 15 posts - 18,451 through 18,465 (of 22,219 total)
tosscrosby (2/6/2009)
Not the BEST bounty hunter in the galaxy - was it a mutual agreement sort of thing? (now we're really getting wierd)
Union.
"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
February 6, 2009 at 12:58 pm
I've given up Boba Fett, so he's available.... which sounds weird.
"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
February 6, 2009 at 12:30 pm
Completely no help to you, this is a great example of how the estimated costs and the actual costs have nothing to do with each other. Jeff would love it.
"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
February 6, 2009 at 11:57 am
Looking at it some more, you're query is joining between tables with this:
JOIN dbo.Citizenships AS C
...
"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
February 6, 2009 at 11:55 am
That's a strange one. The estimated & actual rows are WAY off. You might check the statistics. Let me keep looking.
"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
February 6, 2009 at 11:47 am
TheSQLGuru (2/6/2009)
I have seen this for massively partitioned tables as well.
Really. When did it occur? When the query had to hit lots of the partitions or is it just a...
"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
February 6, 2009 at 11:20 am
Oh no, if it's going to bug the apps, then clearly the data is not guaranteed unique. I'm just saying if the data is going to be unique, there's no...
"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
February 6, 2009 at 9:08 am
Lynn Pettis (2/6/2009)
Grant Fritchey (2/6/2009)
I forgot, swabbie, deck ape, blue jacket, airedale, a-ganger (nasty job).
The more you remind me of what my brother said about the Navy, the more I'm...
"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
February 6, 2009 at 8:13 am
Yeah, that's pretty much my understanding too. Better & more memory management in the 64bit operating system, which benefits SQL Server.
I don't know where you heard that it's 32-bit only...
"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
February 6, 2009 at 8:10 am
It depends on the queries being run. The optimizer will take into account when an index is unique and it can improve performance, but it really does depend on the...
"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
February 6, 2009 at 8:08 am
I forgot, swabbie, deck ape, blue jacket, airedale, a-ganger (nasty job).
"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
February 6, 2009 at 8:04 am
GilaMonster (2/6/2009)
"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
February 6, 2009 at 7:52 am
GilaMonster (2/6/2009)
"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
February 6, 2009 at 7:51 am
Lynn Pettis (2/6/2009)
Grant Fritchey (2/6/2009)
Lynn Pettis (2/6/2009)
"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
February 6, 2009 at 7:48 am
Chris Morris (2/6/2009)
Grant Fritchey (2/6/2009)
"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
February 6, 2009 at 7:45 am
Viewing 15 posts - 18,451 through 18,465 (of 22,219 total)