Sessions & Content

Tags
Search
Conference
Deadlocks: Lets Do One, Understand It, and Fix It
You keep getting warnings and emails about deadlocks, but let's be honest: you're not really sure how they happen or what to do about it. Brent Ozar will show one, use sp_BlitzLock to analyze it, then fix it.
Elementary! The Curious Case of Deceptive Query Optimizer
We will see two important case studies where the optimizer is obviously a criminal who has killed the query performance. We will together with carefully investigate inside the query optimizer understand the reason.
SQL Server Table partitioning – DOs and DON’Ts
When do we get improvement in the performance, and when should we better not choosing partitioning but some other optimization techniques instead? Shall we optimize by using partitioning or yet another index?
<<1>>