References

Microsoft SQL Server Books Online – SQL Programmer: Transact-SQL

• http://www.sql-server-performance.com
• http://www.sql-server-performance.com/rd_optimizing_sp_recompiles.asp
• http://www.idisoft.com/products/sample/sprecompile/sprecompile_overview.htm
• http://vyaskn.tripod.com/differences_between_set_and_select.htm

Use of EXISTS vs COUNT(*):

• http://www.windowsitpro.com/Articles/Index.cfm?ArticleID=38039&DisplayTab=Article

Dynamic SQL:

• http://www.sommarskog.se/dynamic_sql.html

NOLOCK

• http://www.sqlservercentral.com/columnists/WFillis/2764.asp