for date calculations I find it best do build it in steps

-- the date of 12 months ago

select DATEADD(m,-12,getdate())

-- gets the difference between the day of the month...

This is an excellent article that takes the abstract concept of a nonclustered index and explains it in a simple everyday example. Well done. I look forward to...

I just started watching Fringe from Season 1 this year. Awesome.

Reminiscent of the X-Files

thanks for the article reference. i will check it out. the only inserts that will be occurring will be thru the etl so we can manage the statistics.

So if I use the column that is used 100% of the time is the first column in the composite PRIMARY KEY and the second column will only be used...

Thank you for the response. There are other columns in the table so I will go with your suggestion of creating the PK on an identity column and create...