I'm working on a project right now, which I need to ask about limitations of SQL Server. There is an expectancy that we could have some tables with a serious amount of rows, perhaps close to a billion or even more.
- Is this feasible? Can it handle that?
- What are the drawbacks?
- Does it require specific hardware?
- Will it require tuning?
Also, would this be the correct solution to handle this kind of stuff? Would you suggest alternatives that could better handle it considering the same level of security?
BTW I'm not a DBA, so wanted to check with DBAs your opinion on this and recommendations.
Thanks in advance!