Tom.Thomson (5/11/2010)
Cliff Jones (5/6/2010)
What threw me off was "All nonclustered indexes include the clustered index columns in their index pages" . I thought this was incorrect because the clustered index columns are contained in the Leaf Node Data Pages and not every index page.This nearly threw me off too, but I decided that as it didn't say "in all their index pages" it was actually correct and picked the right answer. I can't say that I particularly like questions where one has to take a lawyer-like attitude to the phrasing, but any dba or developer has to read the small print in requirement statements so maybe it's good practice for us and therefor I don't particularly dislike them either (unless they are really silly extreme cases of it, which this one isn't).
I missed this one as well, because I read the clustered index columns to mean all columns, not just the columns comprising the clustered index key. Since the clustered index is the base table, and since all non-clustered indexes do NOT include all columns in the base table... I died.
Really good question though.
__________________________________________________
Against stupidity the gods themselves contend in vain. -- Friedrich Schiller
Stop, children, what's that sound? Everybody look what's going down. -- Stephen Stills