Agreed with Nakul. Another worst practice I often see is that some people have the tendency to write like clauses as
Status LIKE '%Active%' even when a
Status LIKE 'Active%' is sufficient. It is important to remember that the second one can use an index, where as the first one cannot.
commented on Jul 6 2011 12:26AM