Temporal Tables, Partitioning, and ColumnStore Indexes
7 Comments
This post is mostly a thought experiment The thought was something along the lines of: I have a table I want to keep temporal history of. I don’t plan on keeping a lot of data in that table, but the history table can accumulate quite a bit of data. I want to partition the history…
Read More