Database Size

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss content posted by Abhijit » Database Size

89 posts, Page 9 of 9

«««5 6 7 8 9

Database Size

Rate Topic

Display Mode

Topic Options

Author

Message

L' Eomot Inversé

Posted Sunday, February 14, 2010 7:52 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 12:25 PM
Points: 7,110, Visits: 7,184

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
Is minic a gheibheann béal oscailte dorn dúnta.
Is minig a cheapas beul fosgailte dòrn dùinte.

Post #865261

Jeff Moden

Posted Sunday, February 14, 2010 6:59 PM

SSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 4:51 PM
Points: 32,923, Visits: 26,811

Heh... the correct answers are actually missing for all versions.... "Based on Model" and "Too Small". Tongue

--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."

For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #865344

sms1000

Posted Monday, February 15, 2010 5:47 PM

Grasshopper

Group: General Forum Members
Last Login: Sunday, December 23, 2012 4:51 PM
Points: 22, Visits: 68

SQL 2008 3mb for mdf 1 for ldf

Post #865796

Aeterna

Posted Thursday, February 18, 2010 3:52 AM

SSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 5:51 PM
Points: 214, Visits: 403

Jeff Moden (2/14/2010)

Heh... the correct answers are actually missing for all versions.... "Based on Model" and "Too Small". Tongue

Best response yet, IMHO.... Wink

Post #867862

Douglas Elwood

Posted Friday, February 26, 2010 4:52 PM

Old Hand

Group: General Forum Members
Last Login: Yesterday @ 2:32 PM
Points: 396, Visits: 213

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.

Post #873758

Peter Trast

Posted Monday, March 15, 2010 10:24 PM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, March 15, 2013 10:35 AM
Points: 594, Visits: 654

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"? Wink

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

Post #883540

Paul White

Posted Tuesday, March 30, 2010 10:28 AM

SSChampion

Group: General Forum Members
Last Login: Today @ 1:03 AM
Points: 10,990, Visits: 10,543

I do love an ambiguous/controversial QotD: the discussion is always fascinating.

Paul White
SQL Server MVP
SQLblog.com
@SQL_Kiwi

Post #893029

L' Eomot Inversé

Posted Wednesday, March 31, 2010 4:47 AM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 12:25 PM
Points: 7,110, Visits: 7,184

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
Is minic a gheibheann béal oscailte dorn dúnta.
Is minig a cheapas beul fosgailte dòrn dùinte.

Post #893617

Peter Trast

Posted Wednesday, March 31, 2010 8:12 AM

Mr or Mrs. 500

Group: General Forum Members
Last Login: Friday, March 15, 2013 10:35 AM
Points: 594, Visits: 654

Tom.Thomson (3/31/2010)

Paul White NZ (3/30/2010)

I do love an ambiguous/controversial QotD: the discussion is always fascinating.

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

Post #893795

« Prev Topic | Next Topic »

89 posts, Page 9 of 9

«««5 6 7 8 9

Permissions