DeepDive SQL Performance: How to Avoid Poor Performing Code in SQL Server

DM-SQLDDHTAPPC-EN

Take full use of SQL Server Query Engine!

}

Duration: 8 hours

Level: 300

What does this course cover?

SQL Server Query engine is one of the best (if not the best one at all) engines among all relational databases today. To use its potential at full speed, we need to remove all brakes we have introduced – intentionally or not – in our queries. In this course, we will go through these most frequent limitations and we will show how to rewrite the queries and let the query engine run at full speed.

Pre-requisites: What do you need to know?

Experience with SQL Server Administration and Development

“This class is very useful for my daily work”

Karlis Ulmanis

DBA, Riga

WHEN and WHERE is this course running?

Course outline

Key Topics:
  • Search Arguments
  • Parameter Sniffing
  • User-defined Functions
  • Business Logic in Queries
  • Iterative Data Access
  • Plan Guides
  • Query and Table Hints
  • UDFs
  • Computed Columns

All our courses can be offered as a private delivery and tailored for your team's specific needs

WHEN and WHERE is this course running next?