• I've experienced somewhat the same as described, and I have two books I would recommend on this subject:

    SQL Server Execution Plans

    Inside the SQL Server Query Optimizer



    Ole Kristian Velstadbråten Bangås - Virinco - Facebook - Twitter

    Concatenating Row Values in Transact-SQL[/url]