Have you ever wondered why a T-SQL query that usually runs quickly suddenly slows down to a miserable crawl? Maybe there has been a change to the query, but maybe not. Unlike procedural code – where you tell the computer what to do – querying a database is different. You tell the database engine what you want, and the optimizer must figure out how to do it. Luckily, SQL Server provides a tool called the graphical execution plan to help you see what is going on under the covers. Does your query scan a billion row table to find one row? Does it take advantage of an index but then make thousands of trips to the actual table to grab one column? Attend this session to learn how to use graphical execution plans to understand how to make your queries more efficient.
About the presenter:
Kathi Kellenberger is a Microsoft Data Platform MVP with 20 years of experience with SQL Server as a database administrator, developer, and consultant. She is the editor of Simple-Talk, Redgate’s online technical journal, and a volunteer with LaunchCode. Kathi has written several SQL Server books and created four Pluralsight courses. In her spare time, she loves spending time with family and friends, singing, cycling, and climbing the stairs of tall buildings.
6:00 PM - Food and beverages, networking
6:30 PM - User group updates
6:35 PM - Presentation by guest speaker
About the sponsor:
This session is sponsored by RedGate (https://www.red-gate.com/), the leading provider of software for professionals working on the Microsoft data platform.
About the location:
Tyler Technologies has moved to around the corner and down the street to 11 Cornell Rd (Latham 12077). Please come in through the main doors and there will be signs posted to show where the session will be.