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 -
TwitterConcatenating Row Values in Transact-SQL[/url]