When to Use Temporary Tables?

• When we are doing large number of row manipulation in stored procedures.
• This is useful to replace the cursor. We can store the result set data into a temp table, then we can manipulate the data from there.
• When we are having a complex join operation.
• Points to Remember Before Using Temporary Tables
• Temporary table created on tempdb of SQL Server. This is a separate database. So, this is an additional overhead and can causes performance issues.
• Number of rows and columns need to be as minimum as needed.
• Tables need to be deleted when they are done with their work.