- Course
SQL Server: Temporary Objects
Learn how to use temporary tables and table variables correctly, for developers and DBAs from SQL Server 2005 onward
Intermediate
- Course
SQL Server: Temporary Objects
Learn how to use temporary tables and table variables correctly, for developers and DBAs from SQL Server 2005 onward
Intermediate
Get started today
Access this course and other top-rated tech content with one of our business plans.
Try this course for free
Access this course and other top-rated tech content with one of our individual plans.
This course is included in the libraries shown below:
- Data
What you'll learn
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.
SQL Server: Temporary Objects
Intermediate
Table of contents
-
Module Introduction | 38s
-
Demo: Creating A Temporary Table | 1m 41s
-
Demo: SELECT ... INTO A Temporary Table | 1m 45s
-
Demo: Exploring Temporary Table Scope and Lifecycle | 1m 31s
-
Demo: Viewing Temporary Table Metadata | 1m 44s
-
Demo: Temporary Table Definition Modifications | 1m 48s
-
Demo: Temporary Table Data Types | 1m 33s
-
Demo: Temporary Tables and Dynamic SQL | 1m 32s
-
Demo: Local vs. Global Temporary Tables | 1m 58s
-
Demo: Temporary Tables in Modules | 3m 53s
-
Demo: Temporary Tables and Collation Considerations | 2m 7s
-
Demo: Temporary Tables and Constraints | 1m 7s
-
Demo: Temporary Tables and Indexes | 1m 2s
-
Demo: Temporary Tables and IDENTITY columns | 1m 21s
-
Demo: Temporary Tables and Transactions | 1m 20s
-
Demo: Temporary Tables and Statistics | 3m 7s
Joe Sack is a Principal Program Manager in the SQL Server and Azure SQL Database product team at Microsoft, with a focus on query processing. With over 19 years of experience in the industry, Joe is an author and speaker, specializing in performance tuning and optimization.