2013
Pluralsight
Joe Sack
1h 9m
English

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.

-01. Course Introduction
01. Course Introduction.wmv
02. Why use Temporary Objects .wmv
03. Why A Course on Temporary Objects .wmv
04. Course Structure.wmv

-02. Temporary Tables
01. Module Introduction.wmv
02. Demo Creating A Temporary Table.wmv
03. Demo SELECT ... INTO A Temporary Table.wmv
04. Demo Exploring Temporary Table Scope and Lifecycle.wmv
05. Demo Viewing Temporary Table Metadata.wmv
06. Demo Temporary Table Definition Modifications.wmv
07. Demo Temporary Table Data Types.wmv
08. Demo Temporary Tables and Dynamic SQL.wmv
09. Demo Local vs. Global Temporary Tables.wmv
10. Demo Temporary Tables in Modules.wmv
11. Demo Temporary Tables and Collation Considerations.wmv
12. Demo Temporary Tables and Constraints.wmv
13. Demo Temporary Tables and Indexes.wmv
14. Demo Temporary Tables and IDENTITY columns.wmv
15. Demo Temporary Tables and Transactions.wmv
16. Demo Temporary Tables and Statistics.wmv

-03. Table Variables
01. Module Introduction.wmv
02. Demo Declaring A Table Variable.wmv
03. Demo Exploring Table Variable Scope and Lifecycle.wmv
04. Demo SELECT... INTO Table Variable Limitation.wmv
05. Demo Viewing Table Variable Metadata.wmv
06. Demo Table Variable Definition Modification Limitations.wmv
07. Demo Table Variable Data Types.wmv
08. Demo Table Variables and Dynamic SQL.wmv
09. Demo Table Variables in Modules.wmv
10. Demo Table Variable TRUNCATE Limitation.wmv
11. Demo Passing Table Variables as Stored Procedure Parameters.wmv
12. Demo Table Variable Collation Considerations.wmv
13. Demo Table Variables and Constraints.wmv
14. Demo Table Variables and Index Limitations.wmv
15. Demo Table Variables and IDENTITY Column Limitations.wmv
16. Demo Table Variables and Transactions.wmv
17. Demo Table Variables and Statistic Limitations.wmv
18. Demo Table Variables and Parallel Query Execution Limitations.wmv

-04. Tempdb and Temporary Objects Planning
01. Module Introduction.wmv
02. Planning for tempdb Usage.wmv
03. Addressing Allocation Page Contention.wmv
04. Demo tempdb Contention Scenario.wmv
05. Demo Identify tempdb Usage Type.wmv
06. Temporary Object Advantages.wmv
07. Temporary Object Disadvantages.wmv
08. Factors Influencing Temporary Object Usage.wmv
09. Course Summary .wmv

http://pluralsight.com/training

Download File Size:150.27 MB

---