MyPage is a personalized page based on your interests.The page is customized to help you to find content that matters you the most.

I'm not curious

SQL Server: Temporary Objects

Course Summary

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 t

  • +

    Course Syllabus

    ● Course Introduction
        ◦ Course Introduction
        ◦ Why use Temporary Objects?
        ◦ Why A Course on Temporary Objects?
        ◦ Course Structure
    ● Temporary Tables
        ◦ Module Introduction
        ◦ Demo: Creating A Temporary Table
        ◦ Demo: SELECT ... INTO A Temporary Table
        ◦ Demo: Exploring Temporary Table Scope and Lifecycle
        ◦ Demo: Viewing Temporary Table Metadata
        ◦ Demo: Temporary Table Definition Modifications
        ◦ Demo: Temporary Table Data Types
        ◦ Demo: Temporary Tables and Dynamic SQL
        ◦ Demo: Local vs. Global Temporary Tables
        ◦ Demo: Temporary Tables in Modules
        ◦ Demo: Temporary Tables and Collation Considerations
        ◦ Demo: Temporary Tables and Constraints
        ◦ Demo: Temporary Tables and Indexes
        ◦ Demo: Temporary Tables and IDENTITY columns
        ◦ Demo: Temporary Tables and Transactions
        ◦ Demo: Temporary Tables and Statistics
    ● Table Variables
        ◦ Module Introduction
        ◦ Demo: Declaring A Table Variable
        ◦ Demo: Exploring Table Variable Scope and Lifecycle
        ◦ Demo: SELECT... INTO Table Variable Limitation
        ◦ Demo: Viewing Table Variable Metadata
        ◦ Demo: Table Variable Definition Modification Limitations
        ◦ Demo: Table Variable Data Types
        ◦ Demo: Table Variables and Dynamic SQL
        ◦ Demo: Table Variables in Modules
        ◦ Demo: Table Variable TRUNCATE Limitation
        ◦ Demo: Passing Table Variables as Stored Procedure Parameters
        ◦ Demo: Table Variable Collation Considerations
        ◦ Demo: Table Variables and Constraints
        ◦ Demo: Table Variables and Index Limitations
        ◦ Demo: Table Variables and IDENTITY Column Limitations
        ◦ Demo: Table Variables and Transactions
        ◦ Demo: Table Variables and Statistic Limitations
        ◦ Demo: Table Variables and Parallel Query Execution Limitations
    ● Tempdb and Temporary Objects Planning
        ◦ Module Introduction
        ◦ Planning for tempdb Usage
        ◦ Addressing Allocation Page Contention
        ◦ Demo: tempdb Contention Scenario
        ◦ Demo: Identify tempdb Usage Type
        ◦ Temporary Object Advantages
        ◦ Temporary Object Disadvantages
        ◦ Factors Influencing Temporary Object Usage
        ◦ Course Summary


Course Fee:
USD 29

Course Type:


Course Status:



1 - 4 hours / week

This course is listed under Data & Information Management Community

Attended this course?

Back to Top

Awards & Accolades for MyTechLogy
Winner of
Top 100 Asia
Finalist at SiTF Awards 2014 under the category Best Social & Community Product
Finalist at HR Vendor of the Year 2015 Awards under the category Best Learning Management System
Finalist at HR Vendor of the Year 2015 Awards under the category Best Talent Management Software
Hidden Image Url

Back to Top