Sessions & Content

Search
Content Type
Conference
Tags
Elementary! The Curious Case of Deceptive Query Optimizer Pinal Dave
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.
Execution plans ... where do I start? Hugo Kornelis
Execution plans are key to understanding bad query performance. But they can be overwhelming to the new user. Where to start? This session will show the basics!
How to continuously optimise your hybrid SQL Server estate Martin Wild
Automate optimising your hybrid production databases by recording workloads and replaying them either on-prem or onto Azure instances whilst identifying bottlenecks and exploring SQL tuning techniques.
The video is not available to view online.
Kick Start! SQL Server 2019 Performance Tips and Tricks Pinal Dave
Every new release of SQL Server brings a whole load of new features that an administrator can add to their arsenal of efficiency. SQL Server 2019 has introduced many new features. Here is a glimpse of the features we wil
SQL Server Table partitioning – DOs and DON’Ts Margarita Naumova
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>>