Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning Is it possible to create nonclustered index on columns with space and ignore the space so that it does not do a table scan? RE: Is it possible to create nonclustered index on columns with space and ignore the space so that it does not do a table scan?

  • December 18, 2009 at 10:25 am

    #1094168

    What precisely do you mean by "columns with space"?

    Columns with lots of nulls?

    Columns with lots of empty strings?

    Columns that have varchar/nvarchar with leading/trailing spaces?

    Something else?

    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