When I created a date dimension table, instead of calculating all the parts of the dates, I only created the date column, the rest of the columns I used calculated...

I once worked with an application that had only a few lines of code in a stored procedure that inserted a data item into a database table. There was then...