It’s hard to believe I wrote this in 2015. I’d have thought that it was a topic I would have covered earlier than that. Looking back, I think knowing how to use a tally or numbers table is a core SQL skill.
Still on vacation, but re-read The Tally Table and see what you think.
administration AI Azure Backup/Recovery career career2 car update Cloud Computing coping database design databases Database Weekly DevOps disaster recovery encryption Friday Poll goals hardware Humor life Microsoft misc PASS powershell Redgate republish sabbatical security software development software development speaking SQL in the City SQLNewBlogger SQL Prompt SQL Saturday sql server syndicated T-SQL T-SQL Tuesday Tesla travel vacation windows words work
Voice of the DBA 