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 |
|
RH.6530
Starting Member
9 Posts |
 Posted - 2008-01-14 : 13:06:06
|
| This is a question that I have not had an opportunity to test. Was wanting to know if anyone in the SQl world knows the answer. In SQL 2K and 2005 your rolls are limited to 8060 bytes without using varchar(MAX). My question is do you have to specify varchar(max) before your roll can exceed 8060 or does SQL 2005 exceed without specifing varchar(Max). Also does SQL 2005 expand it across multiple pages automatically. Please assist if you can.Thanks |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2008-01-14 : 13:12:28
|
| The pages are still 8KB in 2005.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
RH.6530
Starting Member
9 Posts |
Posted - 2008-01-14 : 13:32:56
|
| I am aware that the pages are still 8k. I was wondering about exceeding 8k with the varchar(Max). Please assist if you can.Thank you, |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2008-01-14 : 14:10:11
|
quote:
Originally posted by RH.6530
I am aware that the pages are still 8k. I was wondering about exceeding 8k with the varchar(Max). Please assist if you can.Thank you,
You could test this yourself in about 2 minutes. Create a table with 2 varchar(8000) columns, and see if you can insert a row with 2 strings of 8000 characters.CODO ERGO SUM |
|
|
|
|
|
|
SQL rows in pages exceeding 8060 bytes