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
