sql-oholic (3/5/2009)
I was hoping to get some tips & tricks .. best practices when using temp tables in sproc
Without seeing code the best I can offer is very general advice.
Make sure all the queries are written as optimally as possible.
Make sure the indexes support the workload
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability