Viewing 15 posts - 3,706 through 3,720 (of 9,722 total)
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
Discourse apparently does not like me. I can't seem to get it loaded.
I'll try again later.
February 7, 2013 at 4:51 am
Oh, heavens. A non-tech webcomic commenting on data consistency.
I am amused: http://www.sandraandwoo.com/%5B/url%5D
February 7, 2013 at 4:44 am
Grant Fritchey (1/31/2013)
BrainDonor (1/30/2013)
jasona.work (1/30/2013)
Now, you want a topic that would *really* generate some responses, start a Star Trek vs Star Wars topic,Babylon 5 or nothing.
+Infinity!
To Infinity and BEYOND!
January 31, 2013 at 5:52 am
And now, if you don't mind, a WOOT of my own.
Penumbra eMag's Bradbury issue got a fantastic review. I selected the 9 finalist stories that got weeded down by...
January 31, 2013 at 5:01 am
Viewing 15 posts - 3,706 through 3,720 (of 9,722 total)