Post reply

Nonclustered indexes

  • February 22, 2010 at 8:24 pm

    #217007

    How are null values handled on a column with a nonclustered index?

    I was asked this question and didn't have an answer. Are the nulls stored in the index itself? Is there a way to view the contents of an index?

    Thanks!

  • February 22, 2010 at 11:43 pm

    #1123441

    They're stored just like any other value.

    You can use DBCC PAGE to view data/index pages if you like. It's undocumented, but there are enough articles mentioning it.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply