SQL Server: Temporary Objects
Pluralsight
Course Summary
Learn how to use temporary tables and table variables correctly, for developers and DBAs from SQL Server 2005 onward
-
+
Course 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 Syllabus
Course Introduction- 3m 36s
—Course Introduction 0m 54s
—Why use Temporary Objects? 0m 55s
—Why A Course on Temporary Objects? 1m 5s
—Course Structure 0m 41sTemporary Tables- 28m 15s
—Module Introduction 0m 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 7sTable Variables- 25m 58sTempdb and Temporary Objects Planning- 11m 16s