Viewing 15 posts - 10,951 through 10,965 (of 22,224 total)
Lynn Pettis (5/3/2012)
SQL Kiwi (5/3/2012)
Lynn Pettis (5/3/2012)
SQL Kiwi (5/3/2012)
One possible test is to imagine one's mother reading the post before hitting 'reply' and wondering if it would make her proud.
Not...
"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 3, 2012 at 10:58 am
Sean Lange (5/3/2012)
/soapbox on
We are starting to lean too far to the arrogant side with many of our replies (and yes I am guilty...
"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 3, 2012 at 10:54 am
Replication & log shipping are going to require you to upgrade the servers involved, so no, you have to do a full upgrade. SSAS & SSRS can be installed seperately,...
"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 3, 2012 at 5:50 am
SSIS is just like the database, you can't go backwards on the versions, so you'll have to move them by hand too.
In addition to data types, make sure 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
May 3, 2012 at 5:49 am
Take a look at Amit Banerjee's write-up on that wait type[/url]. It might be a less than optimal measure due to how it accumulates artificially.
"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 3, 2012 at 5:40 am
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
Viewing 15 posts - 10,951 through 10,965 (of 22,224 total)