Albuquerque SQL Server User Group

What's Happening?

Next Meeting: Fri, Oct 04 2019

October Meeting: How "Quirky" Is Your Update? - with Martin Schoombee

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: https://www.meetup.com/Albuquerque-SQL-Server-User-Group/events/262709826/

The Albuquerque SQL Server User Group (ABQSQL) will be having its next meeting on Friday, October 4th from 11:30 AM to 1:00 PM at Hospital Services Corporation, 7471 Pan American Freeway NE.

Martin Schoombee will be sharing his T-SQL tips and tricks. Please join us for his presentation “How "Quirky" Is Your Update?”. Ask Martin your SQL questions, get to know your peers, and have lunch on us!

Presentation description: "Running totals are a lot easier with today’s T-SQL syntax (SQL Server 2012 and later), but making them perform over large data sets still remains a challenge. This demo-heavy session will explore the good, the bad, and the ugly when it comes to calculating running totals. Our main focus however will be a method coined by Jeff Moden as the "quirky update" which produces lightning-fast results when calculating running totals … sometimes the only option if you're dealing with large volumes and high performance requirements."

Attend this FREE SQL training event!

Kindly RSVP so we know how much pizza we should buy!

PASS membership is not a prerequisite to attend this or any other monthly meeting of the Albuquerque SQL Users Group, however, you can enjoy many benefits of being a member by signing up for a FREE PASS membership at http://www.pass.org/.

 

When

iCal
UTC : Fri, Oct 04 2019 17:30 - 19:00
Event Time : Fri, Oct 04 2019 11:30 - 13:00 Mountain Daylight Time
Your Local Time: Fri, Oct 04 2019 17:30 - 19:00

Where

7471 Pan American Freeway West NE
Albuquerque, New Mexico

Direction: None

Featured Presentation

How "Quirky" Is Your Update?

Speaker: Martin Schoombee, Founder & Chief Data Wrangler 28twelve consulting

Summary: Running totals are a lot easier with today’s T-SQL syntax (SQL Server 2012 and later), but making them perform over large data sets still remains a challenge. This demo-heavy session will explore the good, the bad, and the ugly when it comes to calculating running totals. Our main focus however will be a method coined by Jeff Moden as the "quirky update" which produces lightning-fast results when calculating running totals … sometimes the only option if you're dealing with large volumes and high performance requirements.

About Martin: Martin is an independent Business Intelligence & Analytics consultant, helping customers make sense of their data for more than 12 years.

Attachments

Please be sure to check out our Meetup.com page, and RSVP there for our monthly meetings.

PASS membership is not a prerequisite to attend this or any other monthly meeting of the Albuquerque SQL Users Group, however, you can enjoy many benefits of being a member by signing up for a FREE PASS membership at http://www.pass.org/.

PASSChapterLogo100.jpg  

 

 


 

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