Definitely a good question.
At first I thought is was easy. Then I thought maybe it wasn't - could it be possible that in the case of a clustered index the leaf nodes didn't go where the index was told to go? And then I though that was a crazy idea. And then I vacillated beyween the two possibilities - and ended up trying to look the answer up - but I must have been having a mind block about search terms :doze: because neither MSDN's built in bing nor google turned anything useful up. So I went to bed, and the next day I went with my original thought, picked the easy answer, and got the point - and then discovered from the explanation that it's nicely documented in MSDN on precisely the BOL page that I ought to have looked at first :blush:. And it can't have been jet lag - yesterday I had only had a 4½ hour flight with no time zone change.
Raghavendra Mudugal (12/3/2013)
Very interesting one. Thank you for the post, Carlo. 🙂
(even though having some knowledge on this, I actually never noticed the table changes its FG)
Neither do I!
Yeah, interesting question. Thanks Carlo.
Igor Micev,My blog: www.igormicev.com
Really good question. 🙂
got +1 by pure chance
This one was easy:) Thanks!
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
Viewing 6 posts - 16 through 20 (of 20 total)