Thanks for the comments
rVadim (9/21/2012)
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?
This should probably be restated. What we're after here is keeping people from using scalar valued functions in queries where possible because of the performance hit it takes. We've had a lot of code written that just throws them in there without considering the huge performance hit you can take with the RBAR that is often associated with them.
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 ...
As someone said later on, this needs to be restated as "Don't intermingle DDL within your DML" so that we don't get recompiles all the time