New article on “Temp table VS Table variable” is posted in main website. Check it out from the link below
Most of the SQL Developers/DBA would have come across a situation where they need to store the temporary result sets. This is where Temp tables and Table variables come into effect and helps in storing the data sets in a temporary location