Viewing 15 posts - 14,041 through 14,055 (of 22,232 total)
David Stout (10/26/2010)
PASS and use SSC2010 as the code.
Note 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
October 26, 2010 at 7:45 am
ChrisM@home (10/26/2010)
hosseini.mehran (10/26/2010)
So what is your suggestion?Post the whole query. Could a doctor diagnose a sore throat from looking at a single toe?
And the Actual Execution plan (not an estimated).
"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
October 26, 2010 at 7:15 am
Agreed.
"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
October 26, 2010 at 6:52 am
In order to execute stored procedures you have to GRANT EXECUTE ON something to the user to enable them execution privileges. You can grant execution rights to individual procedures. Another...
"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
October 26, 2010 at 5:30 am
krypto69 (10/25/2010)
not sure if this helps but I created same proc called myproc2...and ran that using same acount number and got 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
October 26, 2010 at 5:28 am
Jack Corbett (10/25/2010)
Grant Fritchey (10/25/2010)
Jack Corbett (10/25/2010)
"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
October 26, 2010 at 5:21 am
krypto69 (10/25/2010)
Not if the next time your run the proc, you use parameters that have better plans with scans... and then all other parameters are better off using seeks.
I cleared...
"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
October 25, 2010 at 11:47 am
Jack Corbett (10/25/2010)
"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
October 25, 2010 at 11:17 am
krypto69 (10/25/2010)
if this was parameter sniffing .wouldn't I see scans in the execution plan?
I don't see scans...all seeks..the execution plan matches the one in stage which runs fast..
If scans/seeks/whatever, if...
"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
October 25, 2010 at 8:48 am
Have statistics been updated on both servers? The indexes rebuilt the same way? Besides the version of sQL Server, is there more/less memory, faster/slower processors, more/fewer disk drives, more/fewer drive...
"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
October 25, 2010 at 8:47 am
Maybe, so you have data that is suspect, like it might not have the right data types in a column or something? The only way to be sure ahead 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
October 25, 2010 at 6:05 am
Jeff Moden (10/24/2010)
"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
October 25, 2010 at 6:01 am
george sibbald (10/24/2010)
Whats 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
October 25, 2010 at 5:50 am
Stefan Krzywicki (10/23/2010)
Grant Fritchey (10/23/2010)
"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
October 23, 2010 at 8:49 am
Absolutely do not use a table valued function for this. Those things are notorious. Since you're saying you can't see it in the execution plan, it's a multi-statement function, right?...
"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
October 23, 2010 at 5:28 am
Viewing 15 posts - 14,041 through 14,055 (of 22,232 total)