row length and index limitations for sql 7 
Author Message
 row length and index limitations for sql 7
Hi,

Is there a limit on the following?  If so,  does anyone know how to find
out what they are?

a) number of columns in a table
b) number of indices on a table
c) table row length

For row length,  do varchar columns count for their declared column size
or just the size of the data?

Thanks,
Scott Walters



Sun, 07 Nov 2004 03:36:22 GMT
 row length and index limitations for sql 7

Scott,

You can find the info. in the BooksOnLine topic "Maximum capacity
specifications"

Dinesh.
--
---
SQL Server FAQ at
www.tkdinesh.com


Quote:
> Hi,

> Is there a limit on the following?  If so,  does anyone know how to find
> out what they are?

> a) number of columns in a table
> b) number of indices on a table
> c) table row length

> For row length,  do varchar columns count for their declared column size
> or just the size of the data?

> Thanks,
> Scott Walters



Sun, 07 Nov 2004 02:36:32 GMT
 row length and index limitations for sql 7
You can copy and paste this url into Internet Explorer:


Or you can find the Maximum Capacity Specifications within Books Online

--
Keith, SQL Server MVP


Quote:
> Hi,

> Is there a limit on the following?  If so,  does anyone know how to find
> out what they are?

> a) number of columns in a table
> b) number of indices on a table
> c) table row length

> For row length,  do varchar columns count for their declared column size
> or just the size of the data?

> Thanks,
> Scott Walters



Sun, 07 Nov 2004 02:45:32 GMT
 row length and index limitations for sql 7
This is great,  thanks.  What about the other question?  Do varchar columns
count for their declared column size in the row length calculation or just the
size of the data?

Scott

Quote:

> Scott,

> You can find the info. in the BooksOnLine topic "Maximum capacity
> specifications"

> Dinesh.
> --
> ---
> SQL Server FAQ at
> www.tkdinesh.com



> > Hi,

> > Is there a limit on the following?  If so,  does anyone know how to find
> > out what they are?

> > a) number of columns in a table
> > b) number of indices on a table
> > c) table row length

> > For row length,  do varchar columns count for their declared column size
> > or just the size of the data?

> > Thanks,
> > Scott Walters



Sun, 07 Nov 2004 04:08:36 GMT
 row length and index limitations for sql 7
The size of the data counts, but you will get a warning message if the
varchar column(s) are defined such that the length of the row could exceed
8060 bytes.

--
Bob Pfeiff
Microsoft Consulting Services

This posting is provided AS IS, with no warranties, and confers no rights.



Sun, 07 Nov 2004 03:28:49 GMT
 row length and index limitations for sql 7
SQL-Server will let you create the table with a defined size of more
than 8060 bytes, but will give a warning. The real size of the data is
what counts. Exceeding 8060 bytes in an actual row will yield an error.

Gert-Jan

Quote:

> This is great,  thanks.  What about the other question?  Do varchar columns
> count for their declared column size in the row length calculation or just the
> size of the data?

> Scott


> > Scott,

> > You can find the info. in the BooksOnLine topic "Maximum capacity
> > specifications"

> > Dinesh.
> > --
> > ---
> > SQL Server FAQ at
> > www.tkdinesh.com



> > > Hi,

> > > Is there a limit on the following?  If so,  does anyone know how to find
> > > out what they are?

> > > a) number of columns in a table
> > > b) number of indices on a table
> > > c) table row length

> > > For row length,  do varchar columns count for their declared column size
> > > or just the size of the data?

> > > Thanks,
> > > Scott Walters



Sun, 07 Nov 2004 03:54:06 GMT
 
 [ 6 post ] 

 Relevant Pages 

1. SQL length limitation with cursors in Sql Server stored proc

2. Line length limitations in PL/SQL

3. How to overcome limitation in SQL text length?

4. SQL query length limitation

5. length limitation of SELECT - SQL statement

6. Row Forwarding and Max row length

7. Request for help - limitation of 32 indexes including foreign indexes

8. SQL Server Replication Row Character Limitation

9. SQL Server 7.0 & row size limitation

10. SQL Server 6.5 Row Size Limitation

11. Query request length limitation problem

12. Display Label length limitation


 
Powered by phpBB® Forum Software