Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mike2000
Starting Member
3 Posts |
 Posted - 2003-08-11 : 14:31:07
|
| I heard this rumor but I am not sure so I like to confirm with you guys. I have a table and let say it has 200 columns and every column had varchar2(30).someone told me that there is a limitation in bytes with 8000 or something??? Is that true, if so what is it????thanks |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2003-08-11 : 14:33:07
|
| Yes, each data page can contain no more than 8,060 bytes.Jonathan{0} |
 |
|
|
mike2000
Starting Member
3 Posts |
Posted - 2003-08-11 : 16:04:32
|
| can you elaborate on 8060 bytes??? what do you mean by each data page???? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-11 : 16:08:51
|
| SQL Server Books Online has the answer to your questions. Please see the topic entitled "Pages and Extents" in BOL.Tara |
|
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
Posted - 2003-08-11 : 16:09:19
|
| But varchar2 is an Oracle type -- are we talking at cross-purposes here? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-11 : 16:10:26
|
| Good catch Arnold. I just thought it was a typo. The information that we have provided is for SQL Server. Don't know what the answer is for Oracle.Tara |
|
|
|
|
|
|
Bytes on the table