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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
