We walk in the dark places no others will enter
We stand on the bridge and no one may pass

create table dbo.tallycalendar ( thedate datetime not null primary key, dayofweek varchar(50) null, isholiday bit null default(0), isworkholiday bit null default(0), isdaylightsavings bit null default (0), holidayname varchar(100) null, ) 
go 
create index ix_tallystuff on tallycalendar (thedate, dayofweek, holidayname)

CREATE TABLE [dbo].[TALLYCALENDAR] ( 
[THEDATE]            DATETIME                         NOT NULL,
[DAYOFWEEK]          VARCHAR(50)                          NULL,
[ISHOLIDAY]          BIT                                  NULL
CONSTRAINT [DF__TallyCale__IsHol__023D5A04] DEFAULT ((0)),
[ISWORKHOLIDAY]      BIT                                  NULL
CONSTRAINT [DF__TallyCale__IsWor__03317E3D] DEFAULT ((0)),
[ISDAYLIGHTSAVINGS]  BIT                                  NULL
CONSTRAINT [DF__TallyCale__IsDay__0425A276] DEFAULT ((0)),
[HOLIDAYNAME]        VARCHAR(100)                         NULL,
CONSTRAINT   [PK__TallyCal__5CB7C64E00551192]    PRIMARY KEY CLUSTERED    (TheDate))

GO

CREATE INDEX [IX_TallyStuff]                     ON [TallyCalendar] (TheDate, DayOfWeek, HolidayName)