|
|
|
SSChampion
Group: Administrators
Last Login: Today @ 8:49 AM
Points: 21,741,
Visits: 5,991
|
|
|
|
|
|
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.
|
|
|
|
|
SSChampion
Group: Administrators
Last Login: Today @ 8:49 AM
Points: 21,741,
Visits: 5,991
|
|
You are welcome. This one stumped me for quite awhile.
Steve Jones
steve@dkranch.net
|
|
|
|
|
SSC Eights!
Group: General Forum Members
Last Login: Monday, October 12, 2009 9:18 AM
Points: 976,
Visits: 33
|
|
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
|
|
|
|
|
SSCertifiable
Group: Moderators
Last Login: Today @ 8:57 AM
Points: 6,361,
Visits: 894
|
|
|
|
|
|
SSChampion
Group: Administrators
Last Login: Today @ 8:49 AM
Points: 21,741,
Visits: 5,991
|
|
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
|
|
|
|
|
SSCertifiable
Group: Moderators
Last Login: Today @ 8:57 AM
Points: 6,361,
Visits: 894
|
|
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
It Depends - My Professional Blog
|
|
|
|
|
SSCrazy Eights
Group: Moderators
Last Login: Friday, November 06, 2009 9:17 AM
Points: 8,296,
Visits: 490
|
|
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.
|
|
|
|
|
SSChampion
Group: Administrators
Last Login: Today @ 8:49 AM
Points: 21,741,
Visits: 5,991
|
|
Thanks. This one was more work that I thought it should be.
Steve Jones
steve@dkranch.net
|
|
|
|
|
Forum Newbie
Group: General Forum Members
Last Login: Wednesday, October 21, 2009 7:09 AM
Points: 1,
Visits: 51
|
|
I haven't hit this problem yet, but will certainly help me when I stumble upon things of this nature. Great Article!!!
|
|
|
|
