6:00PM – 6:30PM social | 6:30PM – 8:30PM meeting
Download the Presentation Material here.
T-SQL Habits & Practices That Can Kill Performance
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.
Vern 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.
Using CLR to Handle Files
A CLR can sometimes fit a special need in a process. It can also take you outside of best practices. In this 20 minute discussion we will discuss the pros and cons of a CLR and briefly walk through a real world example. Bring your own expertise (BYOE) to add to the discussion. We will share an open source project that was created to safely move and rename files after an import task has been completed with TSQL.
Jeff is a rogue CPA/accountant disguised as a SQL guy who cares about simplifying work, code literacy for kids, and pondering the next era of spreadsheets. Jeff leads a 24+ person team in Vancouver WA that has built a framework to unlock Excel as a presentation tier for middle tier services. They enable development partners to remove the frustration that typically is found where software ends and spreadsheets begin. Jeff is a committee member for Oregon SQL PASS chapter user group, the annual SQL Saturday event and promotes kids coding events in the area.
Refreshments graciously provided by ServerLogic.
We wish to acknowledge the OSHU Information Technology Group for supporting Oregon SQL by generously providing the meeting venue.