You didn't necessarily do anything wrong.  There was hopefully a steering committee adjudicating these changes and deciding what was worth it and what wasn't.  I've never worked at a one-size-fits-all. ...

Thanks for this final section.  I'm upgrading a data warehouse from 2005 to 2016.  Based on what I'd read about columnstore indexes up to this point, it didn't seem possible...

On reviewing this, I'm still unsure what the overall goal is.  But when I import from Excel, I create a...

Not an explanation of your problem, but in our warehouse we tend to drop indexes then truncate/load then recreate the indexes. It is generally a lot quicker on low-spec...

Try adding...

No one has been able to demonstrate that the use of INT date/time keys providing any functionality that isn't supplied by the use of actual date/time keys... None, zip,...

I have a data warehouse with some accumulating snapshot type fact tables, all of which have dates and several of which have times at different levels of granularity, with minute...

It sounds like what you are referring to is a "junk dimension."  These can be used to avoid several small dimensions that have only a few answers to each.  They...

Thanks for the tip.  There was no question that had the majority for the answer.  Not sure if the other answer was from the question writer that he would wait. ...

It's been a whole day and there's been no comment from the author of the question about all the comments that say it's number 4, and if it will be...

Not to mention that initials can change. I have comments in my code for who authorized a change that are no longer valid because the young lady...

You aren't, though it's been years and I can only follow the math to...

We may have a difference of definition, but I consider the key generated by...

I also take the time to make them user friendly names except in the case (as has already been pointed out) in temp tables.  Definitely a good habit to get...