SQL Server FAQ
My application makes heavy use of temp tables. Should I be creating temp tables as needed, or should I be using a permanent table over and over instead?
I don't like to delete records in our production database, even though we will never need them again. Does this affect performance?
In my stored procedures I have the option of calling the same data from either a table or a view. For best performance, should I be calling a table or a view?