Maximum table capacity in SQL Server 2008

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?

a table in sql server 2008 can handle large number of records and as @usr mentioned it depends on disk space
but its recommended that if your table has many rows and it keeps on growing that you use Partitioned Table
http://technet.microsoft.com/en-us/library/dd578580(v=sql.100).aspx

When a database table grows in size to the hundreds of gigabytes or more, it can become more difficult to load new data, remove old data, and maintain indexes

more info about it

http://msdn.microsoft.com/en-us/library/ms190787.aspx

and how to implement it
http://blog.sqlauthority.com/2008/01/25/sql-server-2005-database-table-partitioning-tutorial-how-to-horizontal-partition-database-table/

StackExchange Database Administrators Q#18402, answer score: 2