Browse by Tags

• Transact SQL

• Uncertainty erodes confidence, so add that ORDER BY clause.

  I was reading Eric Lippert's blog post , and came across the following quote: "uncertainty erodes confidence in our users that we have a quality product that was designed with deep thought, implemented with care, and behaves predictably and sensibly". Read More... Posted Monday, October 18, 2010 2:18 PM by Alexander Kuznetsov | 4 Comments Filed under: Best Practices, Transact SQL

• In defense of SELECT * in production code, in some limited cases?

  It is well known that SELECT * is not acceptable in production code, with the exception of this pattern: IF EXISTS( SELECT * We all know that whenever we see code code like this: Listing 1. "Bad" SQL SELECT Column1 , Column2 , Column3 , Column4 , Column5 Read More... Posted Thursday, June 03, 2010 2:27 PM by Alexander Kuznetsov | 41 Comments Filed under: Best Practices, Transact SQL