Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
TJTodd
Starting Member
10 Posts |
 Posted - 2010-10-06 : 08:58:34
|
| We have a very large table that is 1 billion rows and will continue to grow. Of these rows - only a small percentage (maybe 1%-3%) of the data is actually considered "active". The "inactive" rows need to be kept because at any point they could again become active.I was thinking of implementing a solution that partitioned the table on an active indicator. The "inactive" partition could be defined on a filegroup that is not backed up as often (because the data isn't changing). The queries that access the data would all be changed to include "WHERE ActiveInd=1". I'm thinking that we could also define filtered indexes so that they only consider these active rows. This is a very new idea, haven't even tried a quick proof of concept with it. Before I start down this path - just curious if there are any potential problems with this approach. ANY feedback would be greatly appreciated.Thanks in advance,Tom |
|
|
|
|
|
Partitioning on a single indicator field