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
Presented by David Morrison at SQLBits XII
Tags (no tags)
  • Downloads
    Video available MP4 Video HD 571 MB
  • SpeakerBIO
    Dave Morrison is senior BI consultant for Itelligence. Having worked in the IT industry for around 15 years his main area of expertise is SQL Server, namely TSQL, query optimisation, indexing, performance tuning and internals etc.
  • Video