Part 2: T-SQL Window Functions in the Realm of Query Logical Processing

The January meeting was so popular that we're continuing this topic in February with Ami Levin of SolidQ.

You'll learn what T-SQL currently offers for window functions, and also show what's missing and how it can be useful for solving real-life challenges.

You'll learn

• Query logical processing and how window functions fit

• The support and limitations of the current implementation of window functions in T-SQL

• Techniques for using window functions to solve common challenges

Ami Levin is a mentor with SolidQ.  He's a regular speaker at SQL Server conferences, and is now co-leader of the Silicon Valley SQL Server User Group. 


Join or login to comment.

  • Thomas M A.

    Thoroughly enjoyed Part 2 presentation. Looking at options for creating online study group for Window functions, using the book shown in class as resource (SQL Server 2012 High-Performance T-SQL Using Window Functions by Itzik Ben-Gan). Even though the title says '2012' there are examples of how to achieve same results using earlier versions of T-SQL in the book. An interesting site for setting up a free study group would be thinkbinder.com. Probably some other options also.

    Anyone interested?

    February 20, 2014

  • James M.

    What an adventure! You can't help but like this guy.
    Next is Round 3.
    Well, we actually got to Windows Functions tonight. The presentation is very educational and a great review of what we all should know. I am looking forward to getting the code notes from the class tonight and the textbook. Pizza was great this week. Jim Moss

    1 · February 19, 2014

  • Cristiano G.

    Sorry guys, unfortunately I'll not be able to be present tonight, hope to catch up all of you the next time!

    1 · February 18, 2014

  • Henry

    Hi Mark,

    I was working on SQL server since last 3 year. I want to join this meetups but I have a clashes with my graduate study as I have class in the evening time.
    So my question is is there any other schedule for these kind of meetup? I would like to join this meetup.

    Thanks & Regards
    Henry

    February 13, 2014

    • Mark G.

      Hi Henry - these meetings are all in the evening. We have a free all day event on Saturday, 3/15/2014 in Mountain View. www.sqlsatsiliconvalley.­com

      February 17, 2014

    • Mark G.

      Also, on Friday, 3/14/2014, there will be four full day training sessions delivered by some of the top SQL Server people around. There are links on the SQLSaturday site. Price is $149 for the all day sessions, also in Mountain View.

      February 17, 2014

  • Brian P.

    Does anyone happen to know of any Sr. Project Lead Engineers, with Splunk experience, that might be looking for a job? I have an opening and need someone ASAP. $150 an hour, contract to hire. It's for a well funded big data analytics start-up here in the Silicon Valley.

    Brian Phelps
    (831)[masked]

    January 29, 2014

Our Sponsors

People in this
Meetup are also in:

Create a Meetup Group and meet new people

Get started Learn more
Allison

Meetup has allowed me to meet people I wouldn't have met naturally - they're totally different than me.

Allison, started Women's Adventure Travel

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy