Quick T-SQL Window Function Articles

Even after six years, I am still presenting at user groups and SQL Saturdays on T-SQL windowing functions. I have found that many data professionals haven’t heard about these great functions. Lots of folks are using ROW_NUMBER, but most haven’t heard about LAG, for example. I recently decided to write a couple of articles for Simple-Talk to give a quick introduction.

The first article, Introduction to T-SQL Window Functions, describes each type of function along with an example or two of each. The second article, T-SQL Window Functions and Performance, tells you what you need to know to get good performance when using these functions.

To learn even more, take a look at my book or my Pluralsight course. These functions simplify many types of queries. If you are writing queries for SQL Server databases, the window function feature is worth checking out!


About Kathi Kellenberger

I am the editor of the online journal Simple Talk. I love talking about SQL Server to anyone who will listen, just ask my seven year old granddaughter. I love to write and teach. I am so humbled and honored to say I am a Data Platform MVP, a volunteer with LaunchCode and co-leader of PASS Women in Technology Virtual Group.
This entry was posted in T-SQL Window Functions. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s