SalemSQL

Salem Area SQL User Group

Next Meeting

Wednesday,

May

09

Vern Rabe: T-SQL Habits and Practices That Can Kill Performance

  • In-Person @ Salem, Oregon, United States

    Public Service Building
    Basement, Room 'A'
    (Check for signs by the elevators.)

    (map)
  • 11:30 - 13:00 Pacific Daylight Time
  • Language: English

All too often we are on a project or given a task where the time or financial constraints require us to develop T-SQL “quick-and-dirty”. Or maybe we have been tasked with quickly improving the performance of some existing T-SQL. These situations often lead to code that later needs to be tuned for better performance. Wouldn’t it be nice if we could satisfy those tight time constraints while also avoiding many of the pitfalls that later plague performance?

In this session we will see ten common T-SQL writing habits that contribute to poor performance. We’ll see WHY each of these patterns can have such negative impact on performance, including examples, and we’ll see one or more alternatives for each that don’t have the same negative impact.

Armed with this knowledge, you will definitely impress your boss with your ability to create fast T-SQL within tight time constraints, and also quickly fix existing T-SQL code. Enjoy the merit raise you’ll get due to your new tuning talents.
 
Bio: Vern Rabe is an independent SQL Server consultant and contract trainer in Portland, OR, and leader of the OregonSQL user group. He has attained MCSE, MCITP (both Administration and Development), and MCT certifications, among others. Vern has been passionate about databases since 1992 and has worked with SQL Server since version 4.21a. He provides broad technical SQL Server knowledge gained from the mixture of academic and practical experiences acquired from his classroom instructing and varied consulting contracts. Vern was honored to have one of the Top 9 PASS Summit session in 2017.

PASSChapterLogo.jpg

 

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids