• Glad to be part of the 27% that got it right, but that's only because I had the 4 to go by.

    I would have probably bypassed the columnstore one otherwise. The rest I was pretty sure on either way, but the columnstore one was more plausible than the bitmap on a computed column one.



    --Mark Tassin
    MCITP - SQL Server DBA
    Proud member of the Anti-RBAR alliance.
    For help with Performance click this link[/url]
    For tips on how to post your problems[/url]