Viewing 15 posts - 1 through 15 (of 35 total)
You're probably not going to like the answer, but the only thing that comes to mind is a new table and load it using SCD2 on a month by...
October 3, 2019 at 3:40 pm
What you're being asked for is an SCD2 model. note this is usually NOT kept within your OLTP solution.
You would need to keep 2 dates in addition to whatever...
October 3, 2019 at 2:46 pm
Not true... you have a column called "Period" that will do the job nicely for a Partitioned View.
Nope... period is the expected period of posting, not the period when it...
October 3, 2019 at 2:37 pm
Hey Jeff. Great idea! I'm going to add this to my notes.
When you have a new historical period, you create a new table and modify the view...
October 3, 2019 at 1:40 pm
Oh... and backup is the wrong word. They don't want a backup I don't really mean off-line backup because at any point in time they need to be able to...
October 3, 2019 at 12:50 pm
Hey Jeff. Great idea! I'm going to add this to my notes.
When you have a new historical period, you create a new table and modify the view definition?
At the...
October 3, 2019 at 12:47 pm
Why don't you just keep the latest backup table and delete the rest?
Because then I will lose what the values were back in March versus December. It's not just...
October 3, 2019 at 12:39 pm
They copy the entire table...
HugeTable_03_2019 includes everything from the beginning of time to the end of the month 03/2019.
HugeTable_04_2019 includes everything from the beginning of time to the end of...
October 2, 2019 at 8:06 pm
Ah... I see what you did there. Using the dynamic to create a static sql view.
September 28, 2019 at 11:56 am
That seems a very odd requirement. Are you sure your users really know what they want?
Probably not... but they want what they want. They have already ignored the fact...
September 27, 2019 at 5:21 pm
The column names in the examples were just there to protect the innocent... I'm open to new names, I can rename them as needed I would suppose.
September 27, 2019 at 3:24 pm
Without having it right in front of me, I'm willing to say that almost all of the columns are either int, datetime, numeric, float or money. The design pushes everything...
September 5, 2018 at 6:51 pm
September 5, 2018 at 7:54 am
I came across this link and I was curious what this group said about that especially when it came to large tables...
http://michaeljswart.com/2013/05/swarts-ten-percent-rule/
September 4, 2018 at 6:37 am
Viewing 15 posts - 1 through 15 (of 35 total)