Recurs1on (9/21/2012)
Query Design ...8.Do not use scalar valued functions SELECT statements
I don't think I understand this. Can you expand?
Recurs1on (9/21/2012)
Query Design ...9.Do not prefix search arguments in a LIKE clause with wildcards
This is not always avoidable. Probably should be phrased like "Try not to..."
Recurs1on (9/21/2012)
Procedure Design1.Do not use both DML and DDL on temp tables within a stored procedure
Really? I can't do this:
CREATE TABLE #Temp(...)
INSERT INTO #Temp ...
--Vadim R.