Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
8060 Limit
Message
From
15/11/2001 08:19:44
 
 
To
15/11/2001 03:11:47
General information
Forum:
Microsoft SQL Server
Category:
Database design
Title:
Miscellaneous
Thread ID:
00581921
Message ID:
00581983
Views:
12
There is no way to increase the page size. As for workarounds, a common technique is to vertically partition the table into two with the most commonly manipulated columns being collected into one of the tables. Another option would be to store an XML document into a text column.

Another option would be to construct an XML document containing some of the data and store it in a text column. This would probably work best for data that never needed to be searched or manipulated on the server.

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Reply
Map
View

Click here to load this message in the networking platform