SQL Tips, Tricks and Misconceptions
This session will cover a range of SQL coding and approaches to various problems faced by anyone writing complex TSQL every day. We'll look at using some under appreciated features and syntax and also some alternate approaches to solving various problems such as unpivoting data and also working with dates.
Finally we'll examine some misconceptions around TSQL & SQL server and look at how they came about and the best way around them
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.