SQL Performance: Good Practices for Beginners:
http://www.codeproject.com/Articles/18839/SQL-Performance-Good-Practices-for-Beginners


Scheduling a SQL Server Profiler Trace:
http://www.mssqltips.com/sqlservertip/1715/scheduling-a-sql-server-profiler-trace/