Creating a date dimension or calendar table in SQL Server

Read this tip to learn how to build and use a calendar table in SQL Server.