Do you dread handing your T-SQL over for code review? Do your queries run slower than you expect? Does the DBA always want to tweak your T-SQL? In this demo heavy session, we’ll take a look at various ways to improve your T-SQL. You’ll learn about formatting T-SQL for readability and why top down design is not the best solution for writing T-SQL. You’ll learn why implicit conversions slow queries down and how to leverage simple techniques for minimizing the performance impact of explicit conversions. By changing some of your T-SQL writing habits you can improve performance of queries from the very beginning.
About the presenter
Mickey Stuewe is a Database Architect. Her focus is on database modeling, T-SQL optimization, requirements gathering, and report design using the SQL Server stack. She is the recent recipient of the “Best New Community Voice” Tribal award from Red Gate. She blogs regularly at mickeystuewe.com and occasionally on other sites such as mssqltips.com. She recently co-authored her first book, SQL Server 2012 Reporting Services Blueprints. She has spoken at Dev Connections, SQL in the City for Red Gate, and various SQL Saturday events. She is also part of the committee that hosts the two Southern California SQL Saturday events each year. She is the President and Founder of a new user group in Irvine, CA called Business Intelligence Group, a PASS Community (BIG PASS Community for short). She makes her home with her husband Dan and their two girls in Southern California.
This event is hosted by the Adelaide SQL Server User Group, and sponsored by LobsterPot Solutions
Join millions of people on Eventbrite.
In order to purchase these tickets in installments, you'll need an Eventbrite account. Log in or sign up for a free account to continue.