SQL Server: Temporary Objects
Learn how to use temporary tables and table variables correctly, for developers and DBAs from SQL Server 2005 onward
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.
Table of contents
- Module Introduction 1m
- Demo: Creating A Temporary Table 2m
- Demo: SELECT ... INTO A Temporary Table 2m
- Demo: Exploring Temporary Table Scope and Lifecycle 2m
- Demo: Viewing Temporary Table Metadata 2m
- Demo: Temporary Table Definition Modifications 2m
- Demo: Temporary Table Data Types 2m
- Demo: Temporary Tables and Dynamic SQL 2m
- Demo: Local vs. Global Temporary Tables 2m
- Demo: Temporary Tables in Modules 4m
- Demo: Temporary Tables and Collation Considerations 2m
- Demo: Temporary Tables and Constraints 1m
- Demo: Temporary Tables and Indexes 1m
- Demo: Temporary Tables and IDENTITY columns 1m
- Demo: Temporary Tables and Transactions 1m
- Demo: Temporary Tables and Statistics 3m
- Module Introduction 1m
- Demo: Declaring A Table Variable 1m
- Demo: Exploring Table Variable Scope and Lifecycle 1m
- Demo: SELECT... INTO Table Variable Limitation 1m
- Demo: Viewing Table Variable Metadata 2m
- Demo: Table Variable Definition Modification Limitations 1m
- Demo: Table Variable Data Types 1m
- Demo: Table Variables and Dynamic SQL 2m
- Demo: Table Variables in Modules 2m
- Demo: Table Variable TRUNCATE Limitation 3m
- Demo: Passing Table Variables as Stored Procedure Parameters 2m
- Demo: Table Variable Collation Considerations 1m
- Demo: Table Variables and Constraints 1m
- Demo: Table Variables and Index Limitations 1m
- Demo: Table Variables and IDENTITY Column Limitations 1m
- Demo: Table Variables and Transactions 1m
- Demo: Table Variables and Statistic Limitations 4m
- Demo: Table Variables and Parallel Query Execution Limitations 1m
