i totally believe in making use of stored procedures and feel that all data operations should be conducted there as it's much closer to the data and far more...

RonKyle - Thursday, November 16, 2017 12:53 PM

What do you mean by this?  My understanding is that stored procedures are the way to go for DML commands.  The business rules...

Not entirely sure about this, or perhaps it's just a disagreement...

Thanks! That was very helpful.  It's possible that only one would be checked per person, but it's also very possible that multiple checks could apply.  But all the choices are...

As it's not a junk dimension, it unfortunately doesn't help.  It's not clear to me what business or technical problem is being solved by this method.  Can you include a...

I've been doing OLAP designs for a long time now and I don't understand what you're doing here.  A clearer explanation at the beginning and maybe some illustration of what would look...

RonKyle - Wednesday, November 1, 2017 1:31 PM

Gives us more daylight in the evening during summer instead of in the morning...

I still don't see the use case. NULL is NULL. An "unknown" bucket doesn't have a lot of meaning beyond knowing how much of your data...

If that's really the full run time, that's very fast for a data warehouse ETL.  I've seen...

   A day has exactly 86,400 seconds in it. The valid times stretch from 00:00:00 to 23:59:59 using hh:mm:ss notation. If you have 86,401 records in...

If '' (empty string) had been a possible answer, I would have selected that.  That was what I worked out before looking at the answers.  This taught me that the...

I've worked with consultants who would want to repeat columns in different tables "to reduce the joins that would be necessary."  In the beginning I'd go along with some of...

Additional information would be helpful.  First, what is the granularity of the fact table(s)?  Is it every change in the application?  Part of your discussion makes me think of an...