I was always under the impression that RAID 5 provides higher read performance than RAID 1; isn't that the whole point of striping?

Hmm, I'd say either RAID 0+1 or RAID 5 would have been correct answers, not RAID 1.

"None of this changes the fact that most companies obviously don't worry about licensing their development boxes."

The last company I worked for didn't worry about licensing development servers (3 SQL Servers, 3 IIS...

A) I agree, stick w/ the DBA questions... I can't answer these license ones

B) I always thought an MSDN subscription was the...

SQLBill:

You didn't quote the second part of the question:

"Each of the servers have a single processor and typically only handles 3 SQL connections at any given time."

That made me think...

PhoenixDBA:

My original quote: "A DBA should make an effort to be as knowledgeable as possible in database fundamentals... "

Note I did not say "relational database fundamentals."  I merely said "database...

SQLBill:

Used on LOCAL machines in production environments; this question (the way I read it) seemed to indicate MSDE being used on 30 different SERVERS that other machines could talk to. ...

Hmm, yeah, I think if I ever saw a company running MSDE in a production environment I wouldn't walk away... I would run!!!

Let me get this straight, BrenBart:

You feel that a DBA shouldn't have to know DBMS foundations but should have to know networking, system administration, and other skills that are peripherally...

Steve, why would you hesitate to mandate knowing Codd's rules or the rules of normalization?  Are you implying that someone can do the job of DBA well without knowing these...

noeld:

The answer didn't say *who* would expect it.  Would the developer expect such behavior?  Certainly not.

I'd like to add:

A DBA should make an effort to be as knowledgeable as possible in database fundamentals... Remember, without knowing why the (a) database is the way it is, you...

Personally I would have gotten rid of the bit column altogether during the "quality control" process and changed it to tinyint.  95% of the time I've seen the bit datatype used,...

I searched Google, Deja, BOL, etc, and couldn't find a single hit on "StallReportThreshold" ... Any unofficial documentation on DBCC LOCK available?

From BOL:

INDEX ( index_val [ ,...n ] )

Specifies the name or ID of the indexes to be used by SQL Server when processing the statement. Only one index hint...