SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Guest Columnist: J. Drew Allen

SQLServerCentral.com profile

   Items 1 to 2 of 2   

Intervals Part 1 - Definitions and Terms

Learn the basic terms and definitions for intervals in SQL Server.  Read more...
By J. Drew Allen 2018/03/12 | Source: SQLServerCentral.com | Category: intervals
Rating: |  Discuss |   Briefcase | 1,120 reads

Solving FIFO Queues Using Windowed Functions

One common request often seen in T-SQL is working with queues of information. In this piece, J. Drew Allen will show to use windowing functions and the OVER clause to process a FIFO queue.  Read more...
By J. Drew Allen 2018/11/30 (first published: 2016/10/06) | Source: SQLServerCentral.com | Category: fifo queues
Rating: |  Discuss |   Briefcase | 3,952 reads
   Items 1 to 2 of 2