SQL Server: Temporary Objects

Learn how to use temporary tables and table variables correctly, for developers and DBAs from SQL Server 2005 onward
More
Learn how to use temporary tables and table variables correctly, for developers and DBAs from SQL Server 2005 onward
More
Table Variables
25m 58s
SQL Server offers different types of temporary objects that you can use for storing, querying and transferring data, however which temporary object type you choose can have a significant influence on the performance and scalability of your workloads. In this course we’ll walk through what the different SQL Server temporary objects are, syntax fundamentals, how to use them and most importantly, how to leverage them effectively. This course is perfect for developers, DBAs, and anyone responsible for writing Transact-SQL code, from complete beginners through to those with more experience. The information in the course applies to all versions from SQL Server 2005 onward.
Table of Contents
Table Variables
25m 58s
Description
SQL Server offers different types of temporary objects that you can use for storing, querying and transferring data, however which temporary object type you choose can have a significant influence on the performance and scalability of your workloads. In this course we’ll walk through what the different SQL Server temporary objects are, syntax fundamentals, how to use them and most importantly, how to leverage them effectively. This course is perfect for developers, DBAs, and anyone responsible for writing Transact-SQL code, from complete beginners through to those with more experience. The information in the course applies to all versions from SQL Server 2005 onward.
Course info
Level
Intermediate
Rating
(241)
Duration
1h 9m
Updated
29 Oct 2013
Course authors

Joe Sack is a Principal Software Architect in the SQL Customer Advisory (SQLCAT) Team at Microsoft. With over 18 years of experience in the industry, Joe is an author and speaker, specializing in performance tuning, high availability and disaster recovery.

Share course