SQL Saturday Charlotte and the Charlotte BI Group is pleased to offer this full day workshop with Adam Machanic.
Tuning Your Biggest Queries
Today's database workloads are all about bigger, better, and more: bigger data, better analytics, and more insights. While these improvements can be great for your business users, on the technology side they often translate into large, lumbering queries that monopolize the server and test the patience of even the calmest of analysts. This full-day seminar is specifically designed to help you tune these extra tough queries. The day begins with an approach to analyzing the biggest query plans, and a discussion around how to understand what kind of plan is ideal given the particulars of a situation. Next you will learn about plan shaping: types of query rewrites that work, which rewrites are bound to fail, and the various query hints you might want to leverage in especially difficult situations. And since bigger queries naturally require more resources, the day will conclude with considerations for CPU, memory, and concurrency, in addition to alternative indexing strategies--including a look at the applicability of columnstores in SQL Server 2016 and beyond. At the end of the day you will be armed with an array of tools and ideas to help you tame even the biggest queries in your environment.
About Adam Machanic
Adam Machanic is a Boston-based SQL Server developer, writer, and speaker. He focuses on large-scale data warehouse performance and development, and is author of the award-winning SQL Server monitoring stored procedure, sp_WhoIsActive. Adam has written for numerous web sites and magazines, including SQLblog, Simple Talk, Search SQL Server, SQL Server Professional, CoDe, and VSJ. He has also contributed to several books on SQL Server, including "T-SQL Querying" (Microsoft Press, 2015) and "SQL Server 2008 Internals" (Microsoft Press, 2009). Adam regularly speaks at conferences and training events on a variety of SQL Server topics. He is a Microsoft Most Valuable Professional (MVP) for SQL Server, a Microsoft Certified IT Professional (MCITP), and an alumnus of the INETA North American Speakers Bureau.