Viewing 15 posts - 3,706 through 3,720 (of 9,726 total)
Does Ask SSC require a different user login than SSC? I'm logged in here, but it won't let me post an answer to someone else's question without logging in again.
February 14, 2013 at 4:15 am
Jeff Moden (2/13/2013)
RBarryYoung (2/8/2013)
Ewww, Tom! I hesitate to ask what "squat thrusts" must mean over there. :sick:
BWAAAAAAAAA-HAAAAAAA-HAAAAAAA!!!!! (clutching my sides and just blew a half dozen Cheerios out my...
February 14, 2013 at 4:13 am
I'm going to SQL Saturday in Omaha, NE. But I'm afraid that and the Jax (and probably Orlando) events are the only SQL Server related events I'll be able to...
February 13, 2013 at 8:15 am
Grant Fritchey (2/13/2013)
I think we're back to the Roadhouse rule set here. Be nice.
And always keep a set of spare tires in the trunk.
February 13, 2013 at 4:54 am
Colin,
Forgive me, but I'm a little confused on the scenario. Am I reading this correctly that your schedules table is not a distinct record set but will always have duplicate...
February 12, 2013 at 9:26 am
Corgi,
I have since learned that if you kill the SPID (not the job), then the SPID will stop the job on its own and rollback. It may take a while,...
February 11, 2013 at 7:48 am
Apple accused of stealing Microsoft's secret DBCC Timewarp! See link for details!
http://www.geekculture.com/joyoftech/%5B/url%5D
and if you can't figure out what part of the comic I'm referring to, let me know.
February 11, 2013 at 5:30 am
Thank you for expounding, Paul. I learned something new this morning.
February 11, 2013 at 5:00 am
Roger,
If I understand things correctly, it isn't about equality of the Account Number match. It's about you asking the engine for more information than the nonclustered index could easily supply....
February 8, 2013 at 12:46 pm
Am I mistaken, Barry? On page 1 of this thread, Craig says he found the solution. Or did I misread that?
February 8, 2013 at 12:00 pm
Lynn Pettis (2/8/2013)
Roger Sabin (2/8/2013)
But I still don't see why the first index is more "correct" when it requires trolling through thousands of records to find...
February 8, 2013 at 11:34 am
L' Eomot Inversé (2/8/2013)
Brandie Tarvin (2/8/2013)
It is morning and my muscles want exercise. Walking, running, jumping jacks, whatever.
You may not be aware what a jumping jack is on this side...
February 8, 2013 at 11:31 am
It might help us a little to see the queries in question.
I'm looking at the pictures generated by the execution plans and I see a difference in the predicate searches...
February 8, 2013 at 11:25 am
It is morning and my muscles want exercise. Walking, running, jumping jacks, whatever.
It is morning, and my boss wants "butt in chair" work.
Sigh. Sometimes I hate my life. Why don't...
February 8, 2013 at 5:21 am
Roger Sabin (2/7/2013)
Name: IDX_MonthlyAccount_YearNum_MonthNum_AltKey_AccountNumber
Indexed Columns: YearNum, MonthNum, AltKey and AccountNumber
Name: IDX_MonthlyAccount_YearNum_MonthNum_AccountNumber
Indexed Columns: YearNum, MonthNum, AccountNumber
If we use the following select statement, the second index (IDX_MonthlyAccount_YearNum_MonthNum_AccountNumber)...
February 8, 2013 at 5:16 am
Viewing 15 posts - 3,706 through 3,720 (of 9,726 total)