Viewing 15 posts - 18,841 through 18,855 (of 22,226 total)
ALTHOUGH...
Now that I think about it, it would probably have to be a compound index using both columns and probably another column because, based on the data types and 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
January 7, 2009 at 11:01 am
Jack Corbett (1/7/2009)
Grant Fritchey (1/7/2009)
Jack Corbett (1/7/2009)
Michael Earl (1/7/2009)
Thanks Jack.
No problem. Just seemed to notice a correlation. I suppose I could be way off, maybe there are other...
"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
January 7, 2009 at 10:57 am
gharris_35 (1/7/2009)
There is an index on the lead_fromdataid and lead_type though there is a seperate index on both fields. I gues that is why SQL Server is using 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
January 7, 2009 at 10:55 am
Lynn Pettis (1/7/2009)
Michael Earl (1/7/2009)
Mass could be may fault.I own a place in Vermont, so I drive through Mass a lot.
Plus, the states are pretty small out here.
Too small for...
"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
January 7, 2009 at 10:48 am
Michael Earl (1/7/2009)
Mass could be may fault.I own a place in Vermont, so I drive through Mass a lot.
Plus, the states are pretty small out here.
OK, well, Oklahoma was 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
January 7, 2009 at 10:40 am
gharris_35 (1/7/2009)
Managed to grad the actual execution plan! Please see attached zip.
I'm probably not going to go through all 30 plans. You'll still need to do what Gail asked for...
"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
January 7, 2009 at 10:37 am
Jack Corbett (1/7/2009)
Michael Earl (1/7/2009)
Thanks Jack.No problem. Just seemed to notice a correlation. I suppose I could be way off, maybe there are other factors involved.
He hasn't said...
"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
January 7, 2009 at 10:28 am
Actually, looking at the data, what if you modified the solution I suggested to get the max ApplicationID instead of the max date? Just use the other columns as matching...
"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
January 7, 2009 at 9:27 am
Too much information in the Estimated execution plan? I don't understand.
You can export the plan as .sqlplan file, zip it and post it here to have someone look 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
January 7, 2009 at 6:58 am
SQL DBA (1/7/2009)
I need differences between Roles, Schemas, Users and Logins. Can anyone help me. Thanks in advance
Have you looked them up on the Books Online? If so, what did...
"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
January 7, 2009 at 6:18 am
To really get an answer, post what Gail says.
For another guess... You're moving so much data that SQL Server is just ignoring the indexes.
BTW, looking at the execution plan, to...
"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
January 7, 2009 at 6:16 am
Probably, in this line of code:
addcount = m + 1
"m" is being treated as a string, not as an integer. That would explain how you would get "11" when 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
January 7, 2009 at 6:13 am
You are going to have to be able to identify the partitioning mechanism, the column or columns that identify where the data is stored. While your post says it doesn't...
"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
January 7, 2009 at 6:10 am
Oopsie. Thanks Noel!
"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
January 6, 2009 at 1:08 pm
I'm sure you can use a stored procedure. Just pass the parameters to one.
"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
January 6, 2009 at 1:07 pm
Viewing 15 posts - 18,841 through 18,855 (of 22,226 total)