The Basics of Using GENERATE_SERIES()

This article shows how GENERATE_SERIES can be used with a few practical examples and a warning on parameters.

GENERATE_SERIES() Breaks Minimal Logging

tl;dr The title says it all. Prologue One of the keys to my personal learning is that, very early in my database career, I taught myself how to make lot’s of rows of Random Constrained Data in a comparatively short time. With the help of a few good folks over time, the method has been […]

How to Expand a Range of Dates into Rows with the SQL Server Function GENERATE_SERIES

In this tip, we cover how to use the GENERATE_SERIES function to expand a range of dates into rows

GENERATE_SERIES Permissions