@Mike Dougherty, @wware, @SanjayAttray
Is it mentioned anywhere in QoD that this change is going to be deployed to production while the DBA is on vacation?
I don’t think I ever mentioned that part, (IMO) it is irrelevant to the QoD.
This question is NOT about performance also, and is phrased in such a way that if you follow the question clearly then you can eliminate the other possibilities and arrive at the right answer easily. This is just my opinion.
However, have you choosed the right answer because you know the concept behind the NULL bitmap in data pages vs Non-Clustered indexes? The intent of this question is to share that information about the difference between them.
If at-least few people realize they learnt something new (about NULL bitmap concept) then this QoD has served its purpose.
Sankar Reddy | http://SankarReddy.com/