Most of the time I come accross the thread wherein user has requested to get started with stored procedure performance tunning , so here are some good reference material for tunning stored procedure http://www.sql-server-performance.com/tips/stored_procedures_p1...