Tackling the Gaps and Islands Problem with T-SQL Window Functions

The gaps and islands problem is a common problem in data analysis. Some examples are:

How long are active periods that my server was running? Or, how long are the periods that the server was down?
On average, how long are the billable periods of my consultants?
What was the longest stretch of days without rain?

In this session, you'll be introduced to the powerful concepts of window functions in T-SQL. With a practical use case, the gaps and islands problem is explained and solved. At the end of the session, you should feel confident in using window functions in your own data analyses.

A basic understanding of T-SQL querying concepts is required to follow this session.

Webcast Date

Thursday, December 19, 2024
1:00:00 PM EST (New York) | 6:00:00 PM UTC

Speaker(s)

Koen Verbeeck is a BI professional, specializing in the Microsoft BI stack with a particular love for SSIS.

Register for this webinar:

First Name*

Last Name*

Business Email*

Organization*

Org Address*

Org City*

Org State

Org Postal Code*

Org Country*

Org Phone*

Industry*

Job Title*

# of SQL Servers*

Organization Size*

SMS reminder

carrier: number: (5551234567)

Save My Details

Register me for these webinars too:

Load Testing Storage Performance for SQL Server
Tuesday, December 3, 2024 - 1:00:00 PM EDT
Speaker(s): Anthony Nocentino - Sponsor: Pure Storage

Reduce Cost for SQL Server Workloads on AWS using Optimize CPUs Feature
Thursday, December 12, 2024 - 1:00:00 PM EDT
Speaker(s): Rafet Ducic and Alex Zarenin - Sponsor: Amazon

Signup for our newsletter

I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.

Tackling the Gaps and Islands Problem with T-SQL Window Functions

Webcast Date

Speaker(s)

Sponsored by

Register for this webinar:

Register me for these webinars too: