Eternal story on temporal objects
Every database professional knows about temporary objects. They can help to solve complex problems and improve application performance when used wisely. However, they can introduce very serious issues when used incorrectly.
This session focuses on the temporary objects available in SQL Server. It talks about temporary tables, table variables, table-valued parameters and discusses their internal implementation and best use-cases for them. The session also covers some aspects of tempdb usage and monitoring and shows how to reduce tempdb load and improve its throughput.