You're correct, it is 8k for all versions of SQL Server. I don't know
where I got 2k from. Blech.
|----------------------------------+--------------------------------------|
|Eric A. Laney |Be cautious in your daily affairs. |
|Systems Engineer | |
|LAN Optimization Team | |
|Verizon Data Services | Today's Fortune|
|Voice: 813.978.4404 | |
|Pager: 888.985.8519 | |
|----------------------------------+--------------------------------------|
"Vygandas
Razhas" To: SQL <[EMAIL PROTECTED]>
<[EMAIL PROTECTED] cc:
com> Subject: RE: Physical Record Size
2001-10-25
01:03
Please
respond to
sql
For SQL Server 2000 - 8K
--
Vygandas Razhas, MCSD, MCCD
Phone: (619) 823-8090
Email: [EMAIL PROTECTED]
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 24, 2001 5:48 AM
To: SQL
Subject: Re: Physical Record Size
If you're running on Microsoft SQL Server, you can total the size for
each
column and round up to the next 2k page boundary. That will give you
the
size of one record. I don't know what the boundaries are for other
DBMSs.
|-----------------------+-----------------------------------------------
--|
|Eric A. Laney |"When you are in it up to your ears, keep your
|
|Systems Engineer |mouth shut"
|
|LAN Optimization Team |
|
|Verizon Data Services |
|
|Voice: 813.978.4404 |
Anonymous|
|Pager: 888.985.8519 |
|
|-----------------------+-----------------------------------------------
--|
"Bernd
VanSkiver" To: SQL
<[EMAIL PROTECTED]>
<cf@shadowdes cc:
ign.net> Subject: Physical Record
Size
2001-10-23
09:17
Please
respond to
sql
Is there a way to figure out how much physical space a specified set of
records is using?
Bernd VanSkiver
[EMAIL PROTECTED]
ColdFusion Developer
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
