Find out more

Here are more online resources:

• General Index Design Guidelines http://msdn.microsoft.com/en-us/library/ms191195.aspx

• About the Missing Indexes Feature http://msdn.microsoft.com/en-au/library/ms345524.aspx

• SQLdiag Utility http://msdn.microsoft.com/en-us/library/ms162833.aspx

• SQL SERVER 2005 Forced Parameterization and Simple Parameterization T-SQL and SSMS http://blog.sqlauthority.com/2007/10/25/sql-server-2005-forced-parameterization-and-simple-parameterization-t-sql-and-ssms/

• Parameterized Queries http://www.databasejournal.com/features/mssql/article.php/3834501/Parameterized-Queries.htm

• The Curse and Blessings of Dynamic SQL http://www.sommarskog.se/dynamic_sql.html

• How to specify output parameters when you use the sp_executesql stored procedure in SQL Server http://support.microsoft.com/kb/262499

• Creating Stored Procedures (Database Engine) http://msdn.microsoft.com/en-us/library/ms190669.aspx

• Activity Monitor http://msdn.microsoft.com/en-us/library/cc879320.aspx

• Batch Compilation...