Estimating size of SQL database

	Home Register Search Help Login

Sponsors
Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax
Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.
Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Recent Posts
Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

Estimating size of SQL database

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP, PHP, and Database >> Estimating size of SQL database

Page: [1]


yogaboy Posts: 377 Joined: 5/22/2004 Status: offline	Estimating size of SQL database - 11/29/2004 14:24:19 Does anyone know a "back of a fag packet" way of calculating the size of a msSQL2000 database? The database hasn't been built yet in any form, and I haven't had a good look at the dataset - but - I do know that the info to be stored is not large (several short strings, all taken from preset choices, no free text) and the total number of records at max is estimated to be 500,000. s=ut?? e=mc(squared)


dpf Posts: 7121 Joined: 11/12/2003 From: India-napolis Status: offline	RE: Estimating size of SQL database - 11/29/2004 14:45:39 quote: The database hasn't been built yet in any form, and I haven't had a good look at the dataset well this sure isnt my area of expertise but it sounds like trying to estimate the size of a house without # rooms, baths, etc. _____________________________ Dan (in reply to yogaboy)


yogaboy Posts: 377 Joined: 5/22/2004 Status: offline	RE: Estimating size of SQL database - 11/29/2004 14:57:12 That is true, but we could all say how big a house would usually be There must be some sort of formula or method out there for this? How am I to even calculate the size of a record? There doesn't seem to be anything I can find on this subject... (in reply to dpf)


rdouglass Posts: 9280 From: Biddeford, ME USA Status: offline	RE: Estimating size of SQL database - 11/29/2004 14:58:01 This link might help: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_02_92k3.asp _____________________________ Don't take you're eye off your final destination. ASP Checkbox Function Tutorial. (in reply to dpf)


yogaboy Posts: 377 Joined: 5/22/2004 Status: offline	RE: Estimating size of SQL database - 11/29/2004 15:02:29 That looks like the thing. Thanks very much - I'm off to find a calculator and brush up on my maths... (in reply to rdouglass)


dpf Posts: 7121 Joined: 11/12/2003 From: India-napolis Status: offline	RE: Estimating size of SQL database - 11/29/2004 15:35:30 quote: That is true, but we could all say how big a house would usually be I wasnt trying to be difficult - it just seemed to me that you were trying to estimate size prematurely but, as usual, rdouglas gave you a good lead ( he usually does). good luck _____________________________ Dan (in reply to yogaboy)


yogaboy Posts: 377 Joined: 5/22/2004 Status: offline	RE: Estimating size of SQL database - 11/29/2004 16:07:12 Don't worry dpf, I knew that. In fact, I was grateful somebody didn't reply with a flame - I knew it was a stupid question, but sometimes they're the ones you need to ask! With what I know it's lucky I'm not proud... (in reply to dpf)