Eternal story on temporal objects

Speaker(s)Dmitri Korotkevitch 

Duration: 60 minutes

Track:

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.


SQLSaturday