Hi Team,

I am trying to learn SQL query optimization using SQL Server 2005. However, I did not find any practical example where I can improve performance by tweaking query alone. Can you please list some example queries - prior and after optimization?

It has to be query tuning – not adding index, not making covering index, not making any alteration to table. No change is supposed to be done on table and index. [ I understand that indexes are important. This is only for learning purpose]

It would be great if you can exaplain using temp table instead of refering any sample databases like adventureworks.

Expecting your support...

Thanks

Lijo