Question Locked

SQL 2005 table limits

0 helpful

4 replies

by rfink Mar 17, 2009 last reply Mar 18, 2009

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Does anyone know what the maximum number of rows a SQL 2005 table can have? I can't find this number on the Microsoft web site any where.

Thanks for you help

4 replies

Clarifications

This is useful

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

Thanks Tony

We're looking at a table that could have billions of rows.

Not fun

Rick

Don't touch though. :p

Rubs crystal ball...

I see big problems heading your way, and as a starter for recomend you don't do

Select * From ReallyHugeTable

and process them on a desktop client. :D

Don't know whether you are au fait with this site buts it's a good 'un

http://www.sql-server-performance.com/

This discussion is closed to new replies.