- 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
Archive for June, 2010
0