Advanced Query Tuning in SQL Server

Rating:
1 vote, average: 5.00 out of 51 vote, average: 5.00 out of 51 vote, average: 5.00 out of 51 vote, average: 5.00 out of 51 vote, average: 5.00 out of 5
Loading...
Please Log in or register to rate

Advanced Query Tuning in SQL Server

DB-203

This course teaches performance tuning of queries from a practical point of view. It includes a series of case studies, each demonstrating a different issue that requires performance tuning. Each case study serves as an opportunity to learn a new topic and to demonstrate the tuning approach.
The course is based on SQL Server 2014, but it is relevant also for SQL Server 2008/R2/2012.

Audience

Target Audience: 
The course is intended for SQL Server DBAs and developers who are responsible for either writing Transact-SQL queries or tuning already written Transact-SQL queries.

Prerequisites:
Students should be familiar with programming in Transact-SQL.

Course Objectives
  • Understand how to read and analyze execution plans
  • Acquire techniques for efficient query tuning
  • Learn new programming and querying methods
Course Topics
  • Case Study #1 – Analyzing Execution Plans
  • Case Study #2 + #3 – Search Arguments
  • Case Study #4 – Implicit Conversions
  • Case Study #5 – Using Covering Indexes
  • Case Study #6 – Temporary Tables vs. Table Variables
  • Case Study #7 – Divide and Rule
  • Case Study #8 – (Not) Using Cursors
  • Case Study #9 – (Not) Using Scalar Functions
  • Case Study #10 – Skewed Data Distribution
  • Case Study #11 – Local Variables
  • Case Study #12 – Ranking Functions
  • Case Study #13 – Transaction Log Overhead
  • Case Study #14 – LOB Data
  • Case Study #15 – Manipulating Hierarchies
  • Case Study #16 – Row Identifiers
  • Case Study #17 – Sparse Columns
  • Case Study #18 – Storing and Accessing Files
  • Case Study #19 + #20 – Manipulating Statistics
  • Case Study #21 – Triggers Best Practices
  • Case Study #22 – Querying XML
  • Case Study #23 – Locking and Blocking
  • Case Study #24 – Nested Transactions
© Copyright - Skilit - Site by Dweb