SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Database Size


Database Size

Author
Message
Tom Thomson
Tom Thomson
One Orange Chip
One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)

Group: General Forum Members
Points: 25447 Visits: 12494
I agree with many of the comments so far: this was not a good QOTD.
The correct answer is that the a default create with no parameters supplied other than the name will create a db with primary data file size same as in the model db and log file size 1MB -or maybe not 1MB but something else? I think Hugo gave some strange rules for initial log file sizes which are not the same as those given in the BOL entries for Create Database in T-SQL Reference for SQL2008, for SQL2005, or for SQL2000, and he referenced MSDN documentation for them.

The options for the answer all all just numbers of MB, so the question needs to specify the version of SQL Server (and maybe whether it is an evaluation copy or some beta or the ready to go version), and even then the person trying to answer would have to assume that it was an implied rule that the model database size was as shipped by MS - and even with that assumption the edition of SQL Server as well as the version would have to be stipulated, because the size of the model database files varies from edition to edition: that the sizes of the model database files are not the same in all editions is documented in BOL: for SQLS 2005 in http://msdn.microsoft.com/en-us/library/ms186388(SQL.90).aspx, for SQL 2008 in http://msdn.microsoft.com/en-us/library/ms186388.aspx, and for SQL 2000 in http://msdn.microsoft.com/en-us/library/aa174522(SQL.80).aspx.

Tom

Jeff Moden
Jeff Moden
SSC Guru
SSC Guru (208K reputation)SSC Guru (208K reputation)SSC Guru (208K reputation)SSC Guru (208K reputation)SSC Guru (208K reputation)SSC Guru (208K reputation)SSC Guru (208K reputation)SSC Guru (208K reputation)

Group: General Forum Members
Points: 208123 Visits: 41973
Heh... the correct answers are actually missing for all versions.... "Based on Model" and "Too Small". :-P

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
If you think its expensive to hire a professional to do the job, wait until you hire an amateur. -- Red Adair

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
sms1000
sms1000
Grasshopper
Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)

Group: General Forum Members
Points: 22 Visits: 68
SQL 2008 3mb for mdf 1 for ldf
anna.ellis@getronics.com
anna.ellis@getronics.com
SSC-Addicted
SSC-Addicted (415 reputation)SSC-Addicted (415 reputation)SSC-Addicted (415 reputation)SSC-Addicted (415 reputation)SSC-Addicted (415 reputation)SSC-Addicted (415 reputation)SSC-Addicted (415 reputation)SSC-Addicted (415 reputation)

Group: General Forum Members
Points: 415 Visits: 609
Jeff Moden (2/14/2010)
Heh... the correct answers are actually missing for all versions.... "Based on Model" and "Too Small". :-P


Best response yet, IMHO.... ;-)
Douglas Elwood
Douglas Elwood
SSC-Addicted
SSC-Addicted (483 reputation)SSC-Addicted (483 reputation)SSC-Addicted (483 reputation)SSC-Addicted (483 reputation)SSC-Addicted (483 reputation)SSC-Addicted (483 reputation)SSC-Addicted (483 reputation)SSC-Addicted (483 reputation)

Group: General Forum Members
Points: 483 Visits: 259
It appears there is confusion rampant with this question.

It asks how large is the database. The question does *NOT* say anything about what are the total sizes of the files created.

Since the .mdf file is essentially the "database" and the .ldf file is the transaction log, this question is poorly worded, badly formed and subject to existing sizes in the model database - which is well beyond the scope (or probably the intention) of the question.

The version issues (SQL 2000/2005/2008) notwithstanding, this is just someone trying to be cute, not ask a meaningful question.

I love the questions that make me think or teach me something - neither of these attributes were present in this question.

Sorry to be harsh, but questions like this should not be posted.
Peter Trast
Peter Trast
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1040 Visits: 655
Not sure where all of these 3mb/1mb numbers are coming from but when I do fresh installs of SQL 2005 or 2008 (which I do a couple of times a month in the classroom from a dvd) the new databases always default to 2mb for mdf and 1mb for ldf and that is for dev, standard or ent editions. I also checked my production servers on 2005 and 2008 and I could not find one that defaulted to anything else... great question and sort of has me thinking, but that creates 2 more questions:

1. Who is going to use a 2MB database?
2. Didn't someone say "size doesn't matter"? ;-)

Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
Paul White
Paul White
SSC-Dedicated
SSC-Dedicated (34K reputation)SSC-Dedicated (34K reputation)SSC-Dedicated (34K reputation)SSC-Dedicated (34K reputation)SSC-Dedicated (34K reputation)SSC-Dedicated (34K reputation)SSC-Dedicated (34K reputation)SSC-Dedicated (34K reputation)

Group: General Forum Members
Points: 34374 Visits: 11359
I do love an ambiguous/controversial QotD: the discussion is always fascinating.



Paul White
SQLPerformance.com
SQLblog.com
@SQL_Kiwi
Tom Thomson
Tom Thomson
One Orange Chip
One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)One Orange Chip (25K reputation)

Group: General Forum Members
Points: 25447 Visits: 12494
Paul White NZ (3/30/2010)
I do love an ambiguous/controversial QotD: the discussion is always fascinating.

Fascinating isn't the word I would use for this discussion: the number of different wrong answers suggested is amazing, very few people seem to have noticed that there is no correct answer available. Perhaps "Astounding" would be a better word ths time (I hesitate to suggest "Appalling" because there were a few good comments).

Tom

Peter Trast
Peter Trast
Ten Centuries
Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)Ten Centuries (1K reputation)

Group: General Forum Members
Points: 1040 Visits: 655
Tom.Thomson (3/31/2010)
Paul White NZ (3/30/2010)
I do love an ambiguous/controversial QotD: the discussion is always fascinating.

Fascinating isn't the word I would use for this discussion: the number of different wrong answers suggested is amazing, very few people seem to have noticed that there is no correct answer available. Perhaps "Astounding" would be a better word ths time (I hesitate to suggest "Appalling" because there were a few good comments).


Surprising is my word. Just shows how little you need to understand the product to use and administer it. No wonder Microsoft rules the software world and I can be a DBA...

Peter Trast
Microsoft Certified ...(insert many literal strings here)
Microsoft Design Architect with Alexander Open Systems
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search