November 18, 2004 at 7:11 am
Does anyone know if the 8k row size limit is going away in SQL Server 2005? I have Beta 2 installed and it won't let me create a table > 8k. My gut feel is that it probably is going to stay that way for the final release. Just wondering if anyone with MS contacts knows different...
The 8k row size limit is a serious issue for people like me that have to migrate an Oracle database with HUGE tables.
November 19, 2004 at 5:11 am
hmmm .. the thought of even wider tables < grin > guess you'll need to normalise !
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
November 19, 2004 at 5:37 am
Here's an answer from Paul Randal, which might clear things up a bit
http://groups.google.de/groups?hl=de&lr=&selm=eUDrwctNEHA.2820%40TK2MSFTNGP10.phx.gbl
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
November 19, 2004 at 9:52 am
Thanks for the link. Very interesting, from what I can determine, there still is an 8k limit in SQL Server 2005 but it doesn't apply to VARCHAR columns. For example, this will not compile:
CREATE TABLE test1
( col1 CHAR(5000),
col2 CHAR(5000)
)
However, this will:
CREATE TABLE test2
( col1 CHAR(5000),
col2 VARCHAR(5000)
)
Apparently, when a VARCHAR column exceeds the 8k limit it will "adjust" itself. Probably creates a pointer to somewhere else, similar to how a TEXT field behaves.
November 19, 2004 at 10:41 am
That is what one-to-one relationships are for. 🙂 Just break your migration into multiple tables and then use views to combine them back together.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply