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?

  • You're welcome.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events