Select of SQL Server Best Practices

• Best Practice for renaming a SQL Server Database by Ashish K. Metha, February 12, 2009
• Best Practices – When Using FILESTREAM Feature of SQL Server 2008 by Ashish, K. Metha, June 11, 2009
• Brad’s Sure DBA Checklist by Brad McGehee, January 20, 2010
• SQL Server Best Practices – Implementation of Database Object Schemas by Microsoft TechNet, SQL Server TechCenter, Library, November, 2008
• SQL Server Best Practices: Use Roles When You Can by Buck Woody, December 07, 2009
• SQL Server Impersonation by Deanna Dicken, February 12, 2010
• Top 6 Myths of Transaction Logs by Robert Davis, October 03, 2010

Select of T-SQL/Database Bad Habits to Kick

• Abusing triggers by A. Bertrand, October 12, 2009
• Avoiding the schema prefix by A. Bertrand, October 11, 2009
• Blind SQL Server installs by A. Bertrand, February 10, 2010
• Creating the user-view by A. Bertrand, March 07, 2010
• Declaring VARCHAR without (length) by A. Bertrand, October 09, 2009
• Choosing the wrong data type by A. Bertrand, October 12, 2009
• Ignoring the principle of least privilege by A. Bertrand, February 12, 2010
• Inconsistent naming conventions by A. Bertrand, October 11, 2009
• Inconsistent table aliasing by A. Bertrand, February 16, 2010
• Making assumptions about IDENTITY by A. Bertrand, October 12, 2009
• Mis-handling date / range queries by A. Bertrand, October 16, 2009
• ORDER BY ordinal by A. Bertrand, October 06, 2009
• Using alias types by A. Bertrand, October 14, 2009
• Using dashes and spaces in entity names by A. Bertrand, October 09, 2009
• Using loops to populate large tables by A. Bertrand, October 07, 2009
• Using old-style JOINs by A. Bertrand, October 08, 2009
• Using SELECT * / omitting the column list by A. Bertrand, October 10, 2009
• Using SELECT or RETURN instead of OUTPUP by A. Bertrand, October 09, 2009
• Using table aliases like (a, b, c) or (t1, t2, t3) by A. Bertrand, October 08, 2009
• Using the visual designer by A. Bertrand, October 14, 2009
• ::
• Not Using “AS” by A. Machanic, October 08, 2009
• ::
• Moving data to procedures vs. moving procedures to data by L. Shea, October 30, 2009

Select of T-SQL Best Practices

• T-SQL Best Practices by Gregory A. Larsen, June 29, 2009
• T-SQL Best Practices – Part 2 by Gregory A. Larsen, July 31, 2009
• Transact-SQL Formatting Standards (Coding Styles) by Robert Sheldon, August 25, 2009
• ::
• My stored procedure “best practices” checklist by Aaron Bertrand, October 30, 2008
• Pre-Compiled Stored Procedures: Fact or Myth by Scary DBA, September 30, 2009
• Twenty tips to write a good stored procedure by Arup Chakraborty, August 10, 2009
• Writing Faster T-SQL by Jacob Sebastian, May 22, 2007
• ::
• Avoiding cursors with SQL Server 2005 by Tim Chapman, March 05, 2009
• Coding SQL Server triggers for multi-row operations by SQLDenis, November 12, 2009
• Comparing Table Variables with Temporary Tables by Wayne Sheffield, June 10, 2009
• Table Variables Are Only in Memory: Fact or Myth by Scary DBA, October 13, 2009
• The Dynamic Tally or Numbers Table by Lynn Pettis, September 22, 2009
• ::
• Dynamic Search Conditions in T-SQL by Erland Sommarskog, February 14, 2009
• If you really must do dynamic SQL… by Colin A. Mackay, September 21, 2009
• OR Condition Performance on SQL Server Pro
• SQL WHERE Clause Optimization on SQL Server Pro
• T-SQL Best Practices – Don’t Use Scalar Value Functions in Column List or WHERE Clauses by Gregory A. Larsen, October 29, 2009
• TSQL LAB 2 – Writing Conditional WHERE Clauses by Jacob Sebastian, September 25, 2009
• Understanding Scans And Seeks by Preethiviraj Kulasingham, August 21, 2009