Viewing 15 posts - 18,826 through 18,840 (of 22,219 total)
From what you've laid out, it sounds OK. Usually, when dealing with a many-to-many table like this, I let the foreign keys also define the primary key. Otherwise you need...
"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 8, 2009 at 5:42 am
If the errors you hit result in a disconnection from SQL Server, there's nothing that can be done to catch or handle those errors. As for the rest, look up...
"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 8, 2009 at 5:41 am
I don't understand either.
Can you show what you've tried that hasn't worked?
"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 1:04 pm
It sounds like you need to get rid of the cursor and just run a query using the data in a join or possibly as part of the where clause.
"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 1:02 pm
BTW, anyone else notice that all you have to do is bring up alcohol and the posting volume goes through the roof?
You buncha lushes.
"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 12:56 pm
Steve Jones - Editor (1/7/2009)
"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 12:42 pm
Except that this portion of the thread started with Steve making fun of Jeff.
Well, he lives in MI. Aren't we supposed to make fun of him?
"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:19 am
I guess you can't argue with that. The worst part is that so many of them have moved North to NH and corrupted a perfectly good state.
Agreed, but I'm...
"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:06 am
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
Viewing 15 posts - 18,826 through 18,840 (of 22,219 total)