What is the Maximum Page Size in SQL Server 2000?

Click here to monitor SSC

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>

Recent Posts

Popular Topics

Home

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Steve Jones » What is the Maximum Page Size in SQL Server...

Add to briefcase

30 posts, Page 1 of 3

What is the Maximum Page Size in SQL Server 2000?

Expand / Collapse

Author

Message

Steve Jones - SSC Editor

Posted Friday, November 02, 2001 12:00 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 8:28 AM
Points: 31,410, Visits: 13,727

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/sjones/pagesize.asp

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #1483

Posted Monday, February 04, 2002 7:36 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, August 19, 2003 12:00 AM
Points: 1, Visits: 1

Thanks for the interesting information. I'm always interested in learning more about how it all fits together. Keep up the good work.

Post #23226

Steve Jones - SSC Editor

Posted Monday, February 04, 2002 11:02 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 8:28 AM
Points: 31,410, Visits: 13,727

You are welcome. This one stumped me for quite awhile.

Steve Jones
steve@dkranch.net

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #23227

Posted Monday, February 04, 2002 2:28 PM

SSC Eights!

Group: General Forum Members
Last Login: Friday, February 15, 2013 10:33 AM
Points: 976, Visits: 48

This article was interesting to me. I have gotten the error when creating tables, however when I create a table in SQL Server 7.0 it lets me even though I exceed the max row size.

Robert Marda

Robert W. Marda
SQL Programmer
Ipreo

Post #23228

Posted Monday, February 04, 2002 5:48 PM

SSCertifiable

Group: Moderators
Last Login: Thursday, May 09, 2013 12:38 PM
Points: 6,462, Visits: 1,384

Access 97 was like that, but Access2K enforces the limit at design time. Not sure which method I like better!

Andy

Andy
SQLShare - Learn One New Thing Each Day
SQLAndy - My Professional Blog
Connect with me on LinkedIn
Follow me on Twitter

Post #23229

Steve Jones - SSC Editor

Posted Tuesday, February 05, 2002 11:32 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 8:28 AM
Points: 31,410, Visits: 13,727

You can create the table in SQL 2000 as well, but you will have issues if the data exceeds the size.

Steve Jones
steve@dkranch.net

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #23230

Posted Sunday, February 10, 2002 5:55 PM

SSCertifiable

Group: Moderators
Last Login: Thursday, May 09, 2013 12:38 PM
Points: 6,462, Visits: 1,384

I agree that MS doesn't do a very good job documenting the page size. While it's interesting to poke around the internals, would be a lot easier if they either just quoted the number you came up with or made it clearer in the docs. I try to avoid getting anywhere NEAR 8000 bytes in width, but if you need to go for the max for whatever reason is nice to know what is really doable. Good article.

Andy

Andy
SQLShare - Learn One New Thing Each Day
SQLAndy - My Professional Blog
Connect with me on LinkedIn
Follow me on Twitter

Post #23231

Posted Monday, February 11, 2002 4:29 AM

SSCrazy Eights

Group: Moderators
Last Login: Tuesday, April 09, 2013 12:53 PM
Points: 8,357, Visits: 684

I found the article informative and quite helpfull. I have long been curious about the size but had no time to test this myself. Good piece of work.

Post #23232

Steve Jones - SSC Editor

Posted Tuesday, February 12, 2002 10:47 AM

SSC-Dedicated

Group: Administrators
Last Login: Today @ 8:28 AM
Points: 31,410, Visits: 13,727

Thanks. This one was more work that I thought it should be.

Steve Jones
steve@dkranch.net

Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help

Post #23233

Posted Tuesday, February 19, 2002 9:19 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, April 22, 2013 9:55 AM
Points: 1, Visits: 87

I haven't hit this problem yet, but will certainly help me when I stumble upon things of this nature. Great Article!!!

Post #23234

« Prev Topic | Next Topic »

Add to briefcase

30 posts, Page 1 of 3

Permissions

Expand / Collapse