Viewing 15 posts - 14,026 through 14,040 (of 22,224 total)
hosseini.mehran (10/27/2010)
Lowell,I put execution plan in the file, how can i attach it in this forum? I can't find any link for attaching here !?
Scroll down a little ways when...
"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 27, 2010 at 7:01 am
Brandie Tarvin (10/27/2010)
Grant Fritchey (10/27/2010)
To the Threadizens/Threadites/Threadoids/Threadopians:Wow, Grant. What a way to make the Threadophiles feel unwanted...
@=)
Oh crud! I knew I was leaving one of the genuses, or is...
"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 27, 2010 at 7:00 am
To the Threadizens/Threadites/Threadoids/Threadopians:
Please, make sure, if you're going to the Summit, you track me down and introduce yourself in person. Some of you I know already, Dixie,Jeff,etc., but some 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 27, 2010 at 5:57 am
Jeff Moden (10/26/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 27, 2010 at 5:32 am
Jeff Moden (10/26/2010)
Mr. Fritchey... Wow! What a great surprise! I don't deserve it but I'm honored. 🙂http://www.sqlpass.org/summit/na2010/Agenda/CommunityExpertsPicks.aspx
Don't be. If I end up with only three or 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
October 26, 2010 at 7:04 pm
tfifield (10/26/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 7:03 pm
Steve Jones - SSC Editor (10/26/2010)
I have a bunch of DVDs and ThinkGeek stuff so far. Based on registrations, it looks like an iPad is a real possibility now.
You can...
"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 9:42 am
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
Viewing 15 posts - 14,026 through 14,040 (of 22,224 total)