Viewing 15 posts - 10,951 through 10,965 (of 22,219 total)
I would not create an ID column just so that you can add a PK and make it clustered.
However, I would probably make one of the other two indexes into...
"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
May 2, 2012 at 10:45 am
GilaMonster (5/2/2012)
"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
May 2, 2012 at 7:36 am
Ben-425648 (5/2/2012)
Grant Fritchey (5/2/2012)
"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
May 2, 2012 at 6:55 am
Wow that's messed up. The estimated rows are different even though the values are the same. It looks like the variables, despite the recompile and the sniffed values, are still...
"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
May 2, 2012 at 6:27 am
Bhuvnesh (5/2/2012)
aaron.reese (5/1/2012)
"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
May 2, 2012 at 5:54 am
It's hard to tell exactly what's happening with incomplete information. Can you post the .sqlplan execution plans for both queries?
"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
May 2, 2012 at 5:52 am
Also, check for other statements before these that might be placing other locks on the system.
"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
May 2, 2012 at 5:24 am
One point to keep in mind, in most circumstances partitioning is not a performance enhancer, but rather a data management enhancer. Performance is frequently degraded somewhat by partitioning. In some...
"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
May 2, 2012 at 5:22 am
Primarily, is the business ready to pay for an upgrade?
Assuming they are, I'm with the last post, Run the Upgrade Advisor first and address any issues it raises. After 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
May 1, 2012 at 12:00 pm
Andy Hyslop (5/1/2012)
Grant Fritchey (5/1/2012)
Yep. A point per post. Varying points for the Question of the Day. So this is +1.
At +12K points you must know the points system inside...
"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
May 1, 2012 at 8:27 am
If you can access the server, what's the status of the "stuck" process? Is it waiting on something? Check sys.dm_exec_requests to see what it's doing. Also, everything is part of...
"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
May 1, 2012 at 8:27 am
Always, always, hit the documentation on MSDN. That's always the first resource, not posts to forums.
"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
May 1, 2012 at 7:20 am
Yeah, Microsoft does. Follow the documentation available on MSDN.
"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
May 1, 2012 at 7:18 am
Yep. A point per post. Varying points for the Question of the Day. So this is +1.
"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
May 1, 2012 at 7:15 am
Compression is about the only way you can put X+5 into a space for X. It's that simple.
"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
May 1, 2012 at 6:33 am
Viewing 15 posts - 10,951 through 10,965 (of 22,219 total)