Skip to main content
Database Administrators

Return to Question

added 5 characters in body
Source Link
JNK
JNK
  • 18k
  • 5
  • 62
  • 98

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 talethe table data file group?

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 tale data file group?

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?

Tweeted twitter.com/#!/StackDBAs/status/206025666456596481
added 58 characters in body
Source Link
JNK
JNK
  • 18k
  • 5
  • 62
  • 98

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 thinkingwondering whether there will be a table capacity limitation if I continue in this structure according to this http://msdn.microsoft.com/en-us/library/ms143432.aspxMSDN article about maximum table size  .

I guessDoes the data file size mentioned in that tale referslink refer to tale data file group  ?

I have an application which inserts more than 1 billion rows annually into a table. This table contains some varchar, 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 thinking whether there will be a table capacity limitation if I continue in this structure according to http://msdn.microsoft.com/en-us/library/ms143432.aspx  .

I guess the data file size mentioned in that tale refers to tale data file group  ?

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 tale data file group?

Post Migrated Here from stackoverflow.com (revisions)
Source Link
GAP
GAP
  • 121
  • 1
  • 3

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, 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 thinking whether there will be a table capacity limitation if I continue in this structure according to http://msdn.microsoft.com/en-us/library/ms143432.aspx .

I guess the data file size mentioned in that tale refers to tale data file group ?