Viewing 15 posts - 3,691 through 3,705 (of 9,706 total)
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
Congratulations, Chad. That's fantastic!
January 31, 2013 at 5:01 am
It shouldn't take too long. But if it's been longer than a couple of days, use the Contact Us page to send in an email asking about it. It might...
January 31, 2013 at 4:03 am
Steve Jones - SSC Editor (1/28/2013)
Grant Fritchey (1/28/2013)
January 29, 2013 at 4:41 am
Stefan Krzywicki (1/28/2013)
January 28, 2013 at 7:33 am
Viewing 15 posts - 3,691 through 3,705 (of 9,706 total)