Sessions & Content

Tags
Search
Conference
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.
Execution plans ... where do I start?
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
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.
Kick Start! SQL Server 2019 Performance Tips and Tricks
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
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>>