Row Size

Question

Row Size

Desh Gupta

SSC Journeyman

Points: 76
More actions
October 14, 2005 at 12:58 am

#111008

How can i increase row size in sql server 2000

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Chris Hedgate One Orange Chip Points: 25041 More actions · Answer 1

What do you mean exactly? If you are referring to the maximum size possible, that is not something you can change. Page size in SQL Server is fixed, and a row cannot span multiple pages. For SQL Server 2005 there are some changes to this (see this and this post in my blog for some info), but it is still basically the same thing.

--
Chris Hedgate http://www.hedgate.net/
Contributor to the Best of SQL Server Central volumes
Articles: http://www.sqlservercentral.com/columnists/chedgate/

Desh Gupta SSC Journeyman Points: 76 More actions · Answer 2

BY DEFAULT SQL SERVER 2000 ROW SIZE IS 8060, I WANT TO INCREASE MORE THAN THIS SIZE, PLEASE TELL ME ANY POSSIBLE WAY IS THERE TO INCREASE ROW SIZE

THANKS

Vee Hall of Fame Points: 3028 More actions · Answer 3

Hi Gupta,

as per me ,

the Other way is to change the dataype to Text ...

Chris Hedgate One Orange Chip Points: 25041 More actions · Answer 4

Like I said, it is not possible to change the page size, and thereby row size, in SQL Server. Why do you want to do this? There is probably a different solution to your problem.

--
Chris Hedgate http://www.hedgate.net/
Contributor to the Best of SQL Server Central volumes
Articles: http://www.sqlservercentral.com/columnists/chedgate/

Clive Strong SSChampion Points: 11222 More actions · Answer 5

As Chris said, it's not possible to do. Sure you can create a table that is bigger than the 8060 limit, but on inserting or updating, you will get an error informing you that you are exceeding the row size limit.

Personally, I don't even like to go over the 8060 limit. If for example I needed multiple large char or varchar columns, you could split this over two tables and join them via a key.