I have an application which inserts more than 1 billion rows annually into a table. This table contains some varchar and bigint columns and one blob column as well.
The 1 billion rows consist of history data which are kept for tracking purpose. So I was wondering whether there will be a table capacity limitation if I continue in this structure according to this MSDN article about maximum table size.
Does the data file size mentioned in that link refer to the table data file group?
Best Answer
There is no practical limit except disk space. I read the table you linked to entirely and checked it.
If you need to go above 16TB you need multiple files (a simple procedure).