Viewing 15 posts - 18,811 through 18,825 (of 22,202 total)
I don't understand either.
Can you show what you've tried that hasn't worked?
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.
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.
January 7, 2009 at 12:56 pm
Steve Jones - Editor (1/7/2009)
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?
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...
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...
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...
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...
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...
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...
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...
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...
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...
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...
January 7, 2009 at 6:58 am
Viewing 15 posts - 18,811 through 18,825 (of 22,202 total)