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
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
