October 26, 2010 at 3:58 pm
I'll be building a data warehouse that will grow by 100's of thousands of rows per day; and the client would like to maintain 7 years of data without truncating. While the business case for this might be a bit flimsy, I need to know what is possible. There is 16TB of space available for this DW.
There may only be 1 fact table, definitely a small number of fact tables. So, given a simple model with lots of data, what are the considerations?
BTW, I am open to non-Microsoft solutions (I've looked at Casandra), but it would definitely be nice to have SSIS and SRS.
October 26, 2010 at 4:08 pm
Thee is no built in limitation of SQL Server that would prevent it.
It will all come down to proper DB design, efficient ETL design, and making sure you have adequate hardware.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply