17th - 19th July 2014

The International Centre, Telford

Platinum Sponsor
david_morrison.jpg

David Morrison

Dave Morrison is senior BI consultant for Itelligence. Having worked in the IT industry for around 14 years his main area of expertise is SQL Server, namely TSQL, query optimisation, indexing, performance tuning and internals etc.
http://tsqlninja.wordpress.com
David Morrison has submitted 6 sessions for SQLBits 12, although the agenda hasn't been chosen yet. See all submitted sessions.

Pending Sessions

In this session we will take an in depth look at statistics.and the role they play in selecting a query plan. We'll also take a look into estimation and how this affects query plan selection. Finally we'll look at plan caching and its ups and downs
In this session we'll take a look at query plans and how they work "under the hood". We'll also take a look at a number of query plan operators and how they work. During this the session we'll also look to identify problem areas in your query plans
In this session we'll take a look at some nice bits of TSQL coding to resolve troublesome coding problems. We'll also look into writing code to make use of some TSQL features that are under used in daily coding.
In this session we will take an in depth look at statistics.and the role they play in selecting a query plan. We'll also take a look into estimation and how this affects query plan selection. Finally we'll look at plan caching and its ups and downs
In this session we'll take a look at query plans and how they work "under the hood". We'll also take a look at a number of query plan operators and how they work. During this the session we'll also look to identify problem areas in your query plans
In this session we'll take a look at some nice bits of TSQL coding to resolve troublesome coding problems. We'll also look into writing code to make use of some TSQL features that are under used in daily coding.

Previous Sessions

This session will cover the "Dark Arts" of SQL Server namely performance tuning. Rather than a traditional look at query tuning it will focus on common misconceptions and a look a why sometimes you get query plans that do "odd" things
This session will take a look at query plan operators, what they are, what they each do, why they get chosen and also how to avoid using them when they perform badly. This will be held mainly in management studio with lots of examples
In this session we will deep an in-depth look at some of the most common query plan operators. We'll look at what they do, how they do it and the circumstances in which they are chosen. We'll also take a look into the ups and downs of each
In this session we'll take a look at some nice bits of TSQL coding to resolve troublesome coding problems. We'll also look into writing code to make use of some TSQL features that are under used in daily coding.