Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Size of Tables
Message
General information
Forum:
Microsoft SQL Server
Category:
Database design
Title:
Miscellaneous
Thread ID:
00320831
Message ID:
00321162
Views:
20
Rick,

I suppose that it's possible. SQL Server uses a different architecture for storing row into a table. The BOL has a brief discussion. You can find a more detailed discussion in the book Inside SQL Server 7.0.

Basically, SQL Server stored data in an 8K page, but only about 8060 bytes can actually be used. Plus there's some overhead on both the page and each row that consumes space.

Also, you can experience fragmentation within SQL Server. Check out DBCC SHOWDCONTIG in the BOL.

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

Click here to load this message in the networking platform