Viewing 15 posts - 18,826 through 18,840 (of 22,215 total)
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
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...
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...
January 7, 2009 at 6:16 am
Viewing 15 posts - 18,826 through 18,840 (of 22,215 total)