hrvoje.piasevoli (7/21/2010)
I myself have written a calendar table w/ one physical date column, one computed persisted integer column and a whole bunch of non-persisted columns calculated from the date column.It
I'm curious did you test and find that using non-persisted columns was faster than pre-calculating and storing all the permutations that you needed? (I guess it would probably depend on the storage system speed and a number of other variables.)