I recently overheard a remark by Greg Low in which he said something akin to ''the most interesting parts of a new SQL Server release are the myriad of small things that are in there that make a developer's life easier'' (I'm paraphrasing because I can't remember the actual quote but it was something like that). The new DATEFROMPARTS ...

Reigniting the [SCDEndDate] debate In November 2009 I wrote a blog post entitled Debunking Kimball Effective Dates where I stated that I was against the Kimball-recommended practice of maintaining a StartDate & EndDate value for every record in a type 2 slowly changing dimension (SCD) table (i.e. the values highlighted in blue in the ...