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 [...]
Posts Tagged ‘patterns & practices’
Select of T-SQL/Database Bad Habits to Kick
Posted: October 15, 2010 in MSSQLTags: patterns & practices
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, [...]
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 [...]
