Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
8060 Limit
Message
From
15/11/2001 03:11:47
 
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Database design
Title:
8060 Limit
Miscellaneous
Thread ID:
00581921
Message ID:
00581921
Views:
46
I have a few tables with a large number of columns and I get a warning.
About the 8K limit on the row size when I create it and rows
can get rejected when inserted in it.

I know this is because SQL Server stores rows in 8k pages.
Is there a way to increase the page size thus increasing the 8k limit? (On DB2 we just make a new buffer pool and create a new tablespace, On Oracle there isn't such a wack limit!)

Does anyone have any advice on how to get around this ridiculously
low limit?

Thanks
Next
Reply
Map
View

Click here to load this message in the networking platform