When a query plan goes wrong

2009

TL; DR

This session looks at some of the common scenarios when query plans can go wrong leading to your performnce suddenly hitting the wall. We will talk through what happens, why it happens and ways in which you can avoid it happening.

Session Details

This session looks at some of the common scenarios when query plans can go wrong leading to your performnce suddenly hitting the wall. We will talk through

what happens
why it happens
ways in which you can avoid it happening.

3 things you'll get out of this session

Simon Sabin's previous sessions

Maximising everyone's super powers - Panel discussion

In this panel we will discuss approaches with leaders in the field who have first hand experience of managing neurodiversity in the work place. Welcome questions from the audience as to how everyone can maximise their and their teams super powers

Achieving PCI with SQL Server - Don't be the next Sony

This session covers all aspects of what you need to do, to enable the storage of card details in SQL Server and achieve PCI certification. We will deep dive into the solutions for storing the data securely using SQL Servers encryption functionality

Performance tuning from the field

In this session we will look at some common practices I have seen in the field that cause performance problems. We will diagnose the cause of the problem and the resolution to the problem.

10 things you should never do with SQL Server

In this session we will look at some of the practices that you shouldn't follow when developing a SQL Server database. We will cover items such as query design, table design, indexes, constraints and more. After this session you will have some practices that you know you should avoid in your SQL Server database if you want the best performance. If you have them you will know what you need to do to resolve them.