Home Forums SQL Server 2008 SQL Server 2008 - General How can we find the Null values on indexed columns from all tables in SQL Server. RE: How can we find the Null values on indexed columns from all tables in SQL Server.

  • June 7, 2013 at 3:26 am

    #1622011

    bslchennai (6/6/2013)

    Yes, i have to take care of all null values because in our database we should not insert null values on indexed columns.

    Why not? What's the problem with null values in an indexed column?

    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