The DBA is constantly ringing your phone complaining about why you did not include an index to support your new stored procedure. They have full access to production and do not understand how hard it is to tune a query with an underpowered development machine and a database which is less than 1/10th the size of the production equivalent. This session will cover query tuning techniques which will stop those phone calls and can be exercised on the worse of development environments. I will focus on query execution plan anti-patterns and faking out the optimizer.
Derik is a data professional focusing on Microsoft SQL Server. His passion focuses around cloud computing, performance, high-availability, disaster recovery, continuous integration, and automated maintenance. His experience has spanned long-term database administration, consulting, and entrepreneurial ventures working in the financial, retail, and healthcare industries.He is a Microsoft Data Platform MVP. When he is not on the clock, Derik devotes his time to the #sqlfamily as the chapter leader for the Fairfield PASS SQL Server user group in Stamford, CT.