Completed
) 2.1 Introduction
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
SQL Server Performance Essentials – Full Course
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction
- 2 ) 1.1 Course Introduction
- 3 ) 1.2 Why Developers should Understand SQL Performance
- 4 ) 1.3 Tools you Need
- 5 ) 1.4 Restore the Sample Database
- 6 ) 1.5 Table Concept
- 7 ) 1.6 Index Concept
- 8 ) 1.7 Summary
- 9 ) 2.1 Introduction
- 10 ) 2.2 Understanding How SQL Server Will Execute a SQL Statement
- 11 ) 2.3 Reading and Interpreting an Execution Plan for a SQL Statement
- 12 ) 2.4 Getting Execution Statistics for a SQL Statement
- 13 ) 2.5 Improving Statement Performance by Adding an Index
- 14 ) 2.6 Rewriting SQL Statements for Improved Performance
- 15 ) 2.7 Common Execution Plan Operations
- 16 ) 2.8 Summary
- 17 ) 3.1 Introduction
- 18 ) 3.2 Index Terminology Refresher
- 19 ) 3.3 What Should I Index in My Database?
- 20 ) 3.4 Why Index Column Order Matters
- 21 ) 3.5 Index Selectivity Explained
- 22 ) 3.6 LIKE Clauses and Index Selectivity
- 23 ) 3.7 How Functions in the WHERE Clause Affect Indexes
- 24 ) 3.8 Include Columns and Covering Indexes
- 25 ) 3.9 Over-indexing
- 26 ) 3.10 Interpreting SQL Server Index Recommendations
- 27 ) 3.11 Summary
- 28 ) 4.1 Introduction
- 29 ) 4.2 Getting Information About SQL Server Sessions and Resource Usage
- 30 ) 4.3 Finding What SQL Statements are Currently Executing
- 31 ) 4.4 Finding the Slowest, Most Expensive SQL Statements
- 32 ) 4.5 Getting SQL Server's Recommendations on Missing Indexes
- 33 ) 4.6 Finding Indexes That are Not Being Used
- 34 ) 4.7 Summary
- 35 ) 5.1 Introduction
- 36 ) 5.2 Setting up a SQL Profiler Trace
- 37 ) 5.3 Running a SQL Profiler Trace
- 38 ) 5.4 Running a Trace as a Server Side Trace
- 39 ) 5.5 Introduction to Using Extended Events for SQL Tracing
- 40 ) 5.6 Setting up an Extended Events Trace Session
- 41 ) 5.7 Running and Configuring the Display Settings for an Extended Events Trace
- 42 ) 5.8 Analyzing Extended Events Trace Data
- 43 ) 5.9 Using Extended Events in SQL Azure
- 44 ) 5.10 Summary
- 45 ) 6.1 Introduction
- 46 ) 6.2 Use Parameterized SQL
- 47 ) 6.3 Are Stored Procedures Faster Than SQL in Application Code?
- 48 ) 6.4 Commit Behavior and Performance
- 49 ) 6.5 Object Relational Mappers Just Generate SQL
- 50 ) 6.6 Solving the N+1 Selects Problem
- 51 ) 6.7 Summary
