Greater Lansing Area for SQL Server (GLASS)

Greater Lansing Area for SQL Server

We are a group of professionals who like to get together to talk about Microsoft SQL Server and related technologies. Meetings are open and free of cost to the public but will require an RSVP so we can get an accurate count for food. 


1. Facilitate networking and create opportunities for our members
2. Deliver quality content for in-depth learning and professional development
3. Encourage community growth and development

Contact Information

1. Mailing list signup:
2. Twitter:
3. LinkedIn:


Next Meeting




Nasty Fast Code Techniques

  • In-Person @ Lansing, Michigan, United States (map)
  • 17:30 - 19:30 Eastern Daylight Time
  • Language: English

Session Title:  Nasty Fast Code Techniques

Presenter: Jeff Moden

Abstract: This session explains and demonstrates the high performance techniques of “Pre-aggregation”, “DRY code”, “Divide’n’Conquer”, “Group-Less Aggregation”, Cascading CTEs, “Column-Based Thinking”, “Inline Blocking”, and the benefit of a “duplicate” index.  Alone, each of those concepts can improve the performance of your code.  Guess what happens when you apply all of those concepts at the same time?  Nasty Fast Code that runs so fast that you’ll think it didn’t run with the side benefits of being incredibly easy to read, troubleshoot, maintain, and modify.  If time allows, we’ll also cover the concept of “Pre-aggregated Moving Window Crosstabs”.This session is very heavily code/demonstration oriented and all code will be made available at the GLASS web site.

Presenter Bio: Jeff Moden is a Senior Database Administrator and SQL Server Mentor at Proctor Financial, Inc., Troy, Mi. With more than 40,000 posts and 3 dozen articles on high performance techniques, Jeff Moden is a strong contributor on where he coined the term “RBAR” (Row By Agonizing Row).  Having two decades’ experience, Jeff is mostly self-trained in what he calls the “Black Arts” of T-SQL and is known worldwide for his informative articles, high performance T-SQL coding methods, and mentoring.  His dedication to helping others has earned him the MS SQL Server MVP award for the last nine years.



Back to Top