Question

Locked

SQL 2005 table limits

By RFink ·
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

This conversation is currently closed to new comments.

4 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

Depends on storage space

by Tony Hopkinson In reply to SQL 2005 table limits
Collapse -

Row limits

by RFink In reply to Depends on storage space

Thanks Tony

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

Not fun

Rick

Collapse -

Well you can look

by Tony Hopkinson In reply to Row limits

Don't touch though.

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.

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

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

Back to Software Forum
4 total posts (Page 1 of 1)  

Software Forums