- 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
Archive for October, 2010
Select of T-SQL/Database Bad Habits to Kick
Posted: October 15, 2010 in MSSQLTags: patterns & practices
0