THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SQL Server 2012 » Windowing functions   (RSS)
  • Connect Digest : 2012-03-06

    This time around, I've got five wish list items for T-SQL / DDL, and then one bonus - a parallelism bug. My thinking on the former is that, since we are either about to start (or are just finishing) locking down the code for SQL Server 2012, this is the first moment where some of these suggestions can be seriously considered without the ''but ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on March 6, 2012
  • Debunking Kimball Effective Dates part 2 – Windowing Functions

    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 ...
    Posted to Jamie Thomson (Weblog) by jamiet on July 13, 2011
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement