SQL Server: Temporary Objects
Temporary objects are everywhere in production SQL Server environments—yet most developers treat them as an afterthought. This course cuts through the confusion, showing you exactly when to use temp tables, table variables, and CTEs, plus the performance pitfalls that catch teams out. You’ll leave with practical patterns that immediately improve query efficiency and code clarity.
AIU.ac Verdict: Essential for SQL developers and data analysts who want to stop guessing about temporary object performance. Joe Sack’s hands-on approach makes abstract concepts stick. The main limitation: assumes solid SQL fundamentals—this isn’t a SQL basics refresher.
What This Course Covers
You’ll explore the three main temporary object types in SQL Server: local and global temporary tables, table variables, and common table expressions (CTEs). The course covers creation syntax, scope rules, indexing strategies, and when each option outperforms the others. You’ll see real-world scenarios where the wrong choice tanks query performance, and how to diagnose and fix them.
Practical labs walk you through optimisation techniques: understanding tempdb contention, leveraging statistics on temp tables, and writing efficient variable declarations. By the end, you’ll confidently choose the right temporary object for any scenario and understand the execution plan implications of each decision.
Who Is This Course For?
Ideal for:
- SQL Server developers: Writing production queries daily and need to eliminate performance guesswork around temporary storage.
- Data analysts: Building ETL pipelines or complex reports where temporary object choice directly impacts runtime.
- Database administrators: Supporting teams and troubleshooting tempdb bottlenecks caused by poor temporary object usage.
May not suit:
- SQL beginners: This assumes you’re comfortable with SELECT, JOIN, and basic T-SQL syntax; it’s not a foundation course.
- Non-SQL professionals: Focused entirely on SQL Server; no value if you work exclusively with other database platforms.
Frequently Asked Questions
How long does SQL Server: Temporary Objects take?
1 hour 8 minutes of video content. Most learners complete it in a single sitting or across two focused sessions.
Do I need SQL Server installed to follow along?
Pluralsight provides hands-on labs and sandboxes, so you can practise without local installation. Having SQL Server available is ideal but not mandatory.
Will this course cover performance tuning in depth?
Yes—execution plans, indexing strategies, and tempdb contention are core topics. You’ll learn how to diagnose and fix real performance issues.
Is this course up to date with recent SQL Server versions?
Joe Sack’s content covers SQL Server 2016 and later. Temporary object fundamentals remain consistent across modern versions, though always check Pluralsight’s course details for the specific version focus.
Course by Joe Sack on Pluralsight. Duration: 1h 8m. Last verified by AIU.ac: March 2026.
