It appears that your browser does not support JavaScript, or you have it disabled. This site is best viewed with JavaScript enabled. If JavaScript is disabled in your browser, please turn it back on then reload this page. If your browser does not support JavaScript, click here for a page that doesn't require javascript.

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 http://tsqlsmellsssdt.codeplex.com . Outside of work he is husband, father of 3 and exasperated archer.

At the heart of SQL Server is the cost based optimizer. This is driven by estimates and they in turn are driven by statistics.
This will be a deep dive into how the optimizer makes its decisions to give you a plan, the things that can go wrong.

The query optimizer is at the heart of SQL Server. Much of the its' internal workings are hidden from the user, but can be revealed by using a selection of undocumented trace flags. This session will be a deep dive into the these internals.

In SQL Server 2014, there have been many changes aimed at giving a more accurate number of rows, and therefore better plans. This session will be a look at these changes, comparing and contrasting with SQL2012/2008 to see how they help.

About

SQL Bits was started by a group of individuals that are passionate about the SQL Server product suite.
There is a breadth of knowledge in the SQL Community that will benefit everyone in the community.
We want to spread that knowledge.

We all work with the SQL community, some of us for many years. We have a range of skills and experiences from being given the MVP award by Microsoft, organising user groups and speaking at events around the world.