T-SQL Performance Tuning
October 22, 2018 9:00am
Everyone that works with SQL Server writes T-SQL, including you. Do you understand how SQL Server interprets queries? Join me for a day of learning strategies for making queries faster and less resource-intensive using T-SQL. I’ll cover the basics such as the order of operations, CRUD statements, and joins. Then I’ll teach you how – and when! – to write aggregations, window functions, subqueries, views, and functions. This full day of T-SQL will refresh the basics and take you through advanced topics!
The class will be a combination of slides, discussion, and demos. If you would like to follow along with demos the day of, here is what you’ll need to succeed:
- An instance of SQL Server 2016 or 2017.
- A copy of AdventureWorks2016 (Available on Github).
- The scripts in the SSMS Project available for download here. (Don’t run them yet!)
Jes Borland is a Premier Field Engineer – SQL Server for Microsoft, where she is a trusted technical adviser, deep technical support, and teacher for her customers. Her experience as a DBA, consultant, and 5-time Data Platform MVP allow her to help the business and the IT teams reach their goals. She has worked with SQL Server as a developer, report writer, DBA, and consultant. Her favorite topics are administration, automation, and performance. She is a former President of FoxPASS, founder of Tech on Tap, and a LessThanDot.com blogger. She frequently presents at user groups, SQL Saturdays, and other community events. She is also an avid runner and chef.
Due to building security at our meeting venue, attendees must be registered, and must present a valid photo ID to building security. Directions to the Wayfair offices can be found here.
Morning coffee, and lunch are provided as part of this class.