PASS Summit 2011 – Slides & Demos

Hi,

Your session(s) was very great and interesting.

It's good to see valuable europeans guy like you at suc international events.

Let me know if you come in Paris to organize a meetin with French MVPs.

Jean-Pierre

MVP SQL Server

Hi Jean-Pierre

I'm really happy that my sessions were so much appreciated! :) At my first chance to come to Paris I'll surely send a email to you so that we can organizes something.

See you soon! :)

Hi Davide,

I just recently watched your session on DVD. It really is helpful. I have a question in regards to the logic in deriving the DateRangeKey.

You've mentioned in the session that if we have "valid_from" and "valid_to" dates of "2009-01-01" to "2009-02-03" the DateRangeKey value for this instance is "200901010203" (slide 33 doesn't show the DateRangeKey). My question is how do we implement the DateRangeKey for end of year validity and/or breakdown such as row 7 on the record set of Slide 33, where we have "2009-12-01" and "2010-01-01". Any advice?

I've also used "2999-12-31" as future date or unknown, e.g. valid_to and valid_from of "2012-03-06" to "2999-12-31" with DateRangeKey "201203069999". I'm not sure if there is any drawback of using non valid "MMDD" values as the last 4 digits of the DateRangeKey.

Thanks in advance.

Julie