Discrepancy on QOD for 7-28-03

Question

Post reply

Discrepancy on QOD for 7-28-03

sbdragoo

SSC Enthusiast

Points: 197
More actions
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

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

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

Jeff Tilkes Right there with Babe Points: 747 More actions · Answer 1

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

mccork SSC-Insane Points: 22288 More actions · Answer 2

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

Cheers,

- Mark

Cheers,
- Mark

Antares686 SSC Guru Points: 125444 More actions · Answer 3

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

sbdragoo SSC Enthusiast Points: 197 More actions · Answer 4

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

cholliet SSC Veteran Points: 266 More actions · Answer 5

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.

SQLBill SSC Guru Points: 51440 More actions · Answer 6

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

mybid2003 SSCertifiable Points: 6620 More actions · Answer 7

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

.

Brian Knight One Orange Chip Points: 27249 More actions · Answer 8

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://www.sqlservercentral.com/columnists/bknight

Brian Knight
Free SQL Server Training Webinars

mybid2003 SSCertifiable Points: 6620 More actions · Answer 9

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

.

mccork SSC-Insane Points: 22288 More actions · Answer 10

quote:
cholliet:
The answers where just a bunch of numbers

And English is Brian's 2nd language?

Cheers,

- Mark

Cheers,
- Mark

Antares686 SSC Guru Points: 125444 More actions · Answer 11

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://www.sqlservercentral.com/columnists/bknight

I would said SQL is your first language.

Antares686 SSC Guru Points: 125444 More actions · Answer 12

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.

cholliet SSC Veteran Points: 266 More actions · Answer 13

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

Yet they all remained forever in the trenches.