APOLOGIES BUT DUE TO UNFORESEEN DIFFICULTIES WE HAVE BEEN FORCED TO RESCHEDULE THIS MEETING IN THE NEAR FUTURE. WE WOULD LIKE TO THANK DAVE FOR HIS UNDERSTANDING AND FLEXIBILITY.
An Introduction to Execution Plans and The Query Optimizer.
One of the most complex areas of SQL Server is the Query Optimizer.
It is the component responsible for turning the logical actions (that are derived from your SQL statements) into physical actions that fetch and process the required data to form your results. Not only does it have to guarantee the correct results (no mean feat when you start to think about it) but it has to do this in a performant way and the route it takes to do this (the output of the optimization process ) is described within the execution plan.
This session will be an introduction to the Optimizer and Execution Plans and take you on a journey to a wider view of the Query Engine.
Once you understand what physical actions are being taken on your logical requests (i.e. your TSQL Statements) then you will be better placed make changes to influence those actions with an end result of a better performing database system.
6.45 – Registration and pizza
7.15 – Session
8.15 – Close
- Dave Ballantyne
Dave is a freelance SQL Server database architect / designer / developer / consultant and lives near London, England. He takes a keen interest in all things SQL and data related and is never happier than picking apart a poorly executing query. He has also created an open sourced add-in for SQL Server data tools (SSDT) called “TSQL Smells”. This detects and reports on ‘suspect’ code within a project and can be found at https://github.com/davebally/TSQL-Smells . Outside of work he is husband, father of 3 and exasperated archer
St James’ Mill
Tuesday 24 May 2016 – 6.45pm til 8.15pm