Next Meeting




Performance Pitfalls from Code Reuse

5:30 PM - 5:45 PM: General Announcement
5:45 PM - 6:15 PM: Dinner & Conversation
6:15 PM - 7:30 PM: Main Presentation
7:30 PM - 7:45 PM: Wrap-up

Featured Presentation:

Performance Pitfalls from Code Reuse

Andy Yun, Senior Database Administrator Ensono, LLC

Have you ever found yourself deconstructing endless layers of nested code? Is your T-SQL codebase written in an object-oriented format with functions and views? Did you know that object-oriented code reuse can come at a significant penalty? Learn why applying object-oriented principles can be extremely detrimental to your T-SQL's performance. You will learn how T-SQL is not like other common programming languages. We will peek inside the Query Optimizer to explore how it generates your Execution Plan. You will be introduced to a T-SQL tool that will aid you in unraveling nested code and together we will explore solutions to help you mitigate these performance pitfalls.

About Andy:
Andy is a Database Developer & Administrator with Ensono, LLC, an IT Managed Services firm. Leveraging knowledge of SQL Server Internals and extensive experience in highly transactional environments, Andy strives to make T-SQL leaner and meaner. Passionate about passing his knowledge onto others, Andy actively participates in the SQL Server community, as co-Chapter Leader of the Chicago Suburban User Group, and by speaking at regional User Groups & SQL Saturdays.