http://www.codeproject.com/Articles/43629/Top-10-steps-to-optimize-data-access-in-SQL-Server

http://www.codeproject.com/Articles/34372/Top-10-steps-to-optimize-data-access-in-SQL-Server

http://www.codeproject.com/Articles/35665/Top-10-steps-to-optimize-data-access-in-SQL-Server

http://www.codeproject.com/Articles/34142/Understanding-Set-based-and-Procedural-approaches

http://www.codeproject.com/Articles/36091/Top-10-steps-to-optimize-data-access-in-SQL-Server

http://www.codeproject.com/Articles/43629/Top-10-steps-to-optimize-data-access-in-SQL-Server