Do it now: Date and Number tables

Your production environment needs Date and Number tables, to help you Get Stuff Done in sets instead of RBAR*.

Doug Lane has a video on Why You Simply Must Have a Date Table. I really loved the intro.

A Numbers Table is also very useful for similar reasons. Jeff Moden has been harping on about so-called Tally Tables for years.

Check out Greg Larsen’s post, Creative Solutions by Using a Number Table, for some nifty uses.


* Jeff Moden coined the acronym RBAR, or Row By Agonizing Row.

Author: randolph

Randolph West is a Microsoft Data Platform MVP, and has worked with SQL Server since the late 1990s. When not consulting, he can be seen acting on the stage and screen, or doing voices for independent video games. Randolph is available for talks on SQL Server, and technology in general. He also offers training for junior DBAs. Connect with Randolph on Google+ or Twitter.