DeepDive SQL Performance: How to Avoid Poor Performing Code in SQL Server
Take full use of SQL Server Query Engine!
Duration: 8 hours
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
WHEN and WHERE is this course running?
- Search Arguments
- Parameter Sniffing
- User-defined Functions
- Business Logic in Queries
- Iterative Data Access
- Plan Guides
- Query and Table Hints
- Computed Columns