Post reply

Discrepancy on QOD for 7-28-03

  • July 28, 2003 at 7:44 am

    #106271

    I searched the Books on line for "Maximum Capacity Specifications" and found where the maximum memory for Windows 2K Advanced server which SQL Server 2K will use is listed as 8GB. However, If you query for "Managing AWE Memory" and read this section it indicates that:

    "SQL Server 2000 can use as much memory as Windows 2000 Advanced Server or Windows 2000 Datacenter Server allows"

    Can anybody explain the conflicting information here?

    Thanks in advance,

    Scott B Dragoo

    GIS Systems Analyst

    Information Systems Department

    Sangamon County, Illinois

    scottd@co.sangamon.il.us

    sbdragoo@yahoo.com

  • July 29, 2003 at 5:58 am

    #467443

    No conflicting information here...

    Win2k Advanced Server supports up to 8gb of ram, so SQL server can only support 8gb on Advanced Server.

    Datacenter supports up to 64gb

  • July 29, 2003 at 6:11 am

    #467444

    Maybe we should sack the clown who put 16gb in the box?

    Cheers,

    - Mark


    Cheers,
    - Mark

  • July 29, 2003 at 6:17 am

    #467447

    So Answer E fire the dumb@$$ who put 16GB on a machine with OS support for only 8GB.

  • July 29, 2003 at 7:27 am

    #467479

    So answer "F" bang head on desk for not remembering that Advanced can't support that much RAM.....somedays you bite the world - somedays the world bites back....

  • July 29, 2003 at 11:28 am

    #467543

    No one even noticed that the question was incorrectly worded. The question read "How much RAM can the SQL Server see"? The answers where just a bunch of numbers. OK So you choose 8, do you just take it for granted that this means gigabytes? I'm sure everyone did. The way the question is structured it sounds as though, if you choose the answer 8, that the server can see 8 RAM. So the server can see eight male sheep? Then the most correct answer would have been "None of the below". I think English must be a second language for the person that constructed this question. They may know about SQL Server, but they don't know English grammar. It would especially be nice if they could learn sentence structure before posting another QOD.

  • July 29, 2003 at 11:39 am

    #467548

    Cholliet,

    I can't let this pass by.

    I can understand your frustration. However, this is an International site. (It might be run by people in the USA, but the users/members are from all over the world). ENGLISH is not the first language for everyone on this site (for some it's not even their third language - some use translator programs).

    Further, the site owners operate this site 'outside of work'. This isn't their job. They don't have time to edit everyone's post, script, article, etc.

    Others may have also mis-interpreted the QOD, but I believe most understood they were talking about GB of RAM not sheep or anything else. After all, the QOD did use GB with the numbers in the question itself.

    Please bear with the mis-spellings, incorrect grammar, etc. If you really don't understand something ask the poster to clarify themselves.

    -SQLBill

  • July 29, 2003 at 11:58 am

    #467556

    cholliet,

    I was just wondering if you have been offered water with "spoon" or "cup", when you request someone that you would like to have some water.... (not glass of water)

    I would imagine that you would normally be offered water with glass unless you request yourself.

    Did you get the point? Think about it...

    .

  • July 29, 2003 at 1:22 pm

    #467572

    I'm afraid this question was my doing and English is hardly my 2nd language (although my ex-English teacher may say otherwise). I made the assumption that since I was speaking of GB the entire question, that readers would assume GB. It sounds like that was a poor assumption on my account. It has been fixed though now for future users taking the test.

    Brian Knight

    bknight@sqlservercentral.com

    http://qa.sqlservercentral.com/columnists/bknight

    Brian Knight
    Free SQL Server Training Webinars

  • July 29, 2003 at 1:27 pm

    #467573

    Brian,

    We do use the common slang in our day to day DBA life. I think that there is nothing wrong on your part.

    Anyway we can leave this issue and don't need to consider further I guess...

    .

  • July 29, 2003 at 2:55 pm

    #467605

    quote:

    cholliet:

    The answers where just a bunch of numbers

    And English is Brian's 2nd language?

    Cheers,

    - Mark


    Cheers,
    - Mark

  • July 29, 2003 at 3:21 pm

    #467612

    quote:

    I'm afraid this question was my doing and English is hardly my 2nd language (although my ex-English teacher may say otherwise). I made the assumption that since I was speaking of GB the entire question, that readers would assume GB. It sounds like that was a poor assumption on my account. It has been fixed though now for future users taking the test.

    Brian Knight

    bknight@sqlservercentral.com

    http://qa.sqlservercentral.com/columnists/bknight

    I would said SQL is your first language.

  • July 29, 2003 at 4:58 pm

    #467629

    Of excuse me I meant

    DECLARE @makecomment VARCHAR(100)

    SET @makecomment = 'SAYSOMETHING'

    IF @makecomment IS NOT NULL

    PRINT 'I would said SQL is your first language.'

    ELSE

    --Don't bother.

  • July 30, 2003 at 7:31 am

    #467729

    Flame on, Mr. Businessman, you can't speak like me.

    Yet they all remained forever in the trenches.

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply