December 4, 2013 at 10:49 am
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.
Tom
December 7, 2013 at 2:28 am
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!
Thanks & Best Regards,
Hany Helmy
SQL Server Database Consultant
December 12, 2013 at 2:04 am
Yeah, interesting question. Thanks Carlo.
Igor Micev,My blog: www.igormicev.com
December 12, 2013 at 2:41 am
Really good question. 🙂
January 2, 2014 at 3:06 am
good one!
got +1 by pure chance
March 11, 2014 at 3:42 pm
This one was easy:) Thanks!
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
Viewing 6 posts - 16 through 20 (of 20 total)
You must be logged in to reply to this topic. Login to reply