How many records can SQL Server hold?

How many records can a SQL database handle?

100,000 rows a day is not really that much of an enormous amount. (Depending on your server hardware). I have personally seen MSSQL handle up to 100M rows in a single table without any problems. As long as your keep your indexes in order it should be all good.

Can SQL handle millions of records?

Yeah, it can handle billions of records. If you properly index tables, they fit in memory and your queries are written properly then it shouldn't be an issue.

How many records can a database hold?

The maximum size of a single record within a table is 2 KB (excluding memo fields and OLE object fields). So if all records are maxed out, a table could hold 1 GB/2 KB ~ 524288 records. But if the records are smaller, the number of records can be (much) larger.

Can SQL Server handle billions of rows?

Initially it will start with few billions records and will eventually over few month will be 50 trillion or more. There is really no chance of that working, SQL Server does not scale much above a couple of billion rows at best.