If the practice tests are any example, I'm thinking you have 145 minutes total for the exam.  The other stuff may be covered by NDAs (I haven't taken the test...

Has anyone noticed whether DBAs get outsourced?  I've heard of programming, help desks and other call centers getting outsourced, but I've never heard one instance of DBA outsourcing.

I can't imagine how anyone could...

HA!  I'm not going crazy!!!

I just found the errata for this book on Microsoft's Website.  No wonder I'm frustrated.  There are a LOT of typos in this stupid book.

Moral of...

AHA!  I think I finally found the the way to turn XML datatype data into data you can operate on.

Does the Nodes() method sound correct to anyone? 

Seems to me that they were definitely more worried about the education problem, though.

And people think schools in Florida are bad! @=)

I find it extremely amusing that U.S. companies are starting to go elsewhere because of rising salaries and labor shortages.  What did they think was going to happen once everyone...

Sam,

Don't be too hard on the the people who ask this question.  I myself asked the question when I was first working on my MCDBA.  I had no experience with...

Hmm. Very interesting.  So the rhetorical question is: if there is only one way available of doing a sim on the exam, how can you possibly get one wrong other than...

It would be the pre-summary details kept in that data type, which is why I was concerned about using mathmatical operations on it. 

I see your point about everything else. ...

Yikes!

I'm not personally worried, but I have to wonder how many people fail the exams because the sims are different from each other...

That makes sense.  I just hope whichever technique is used is consistant between the various exams. 

The short answer is "You can't".

Standard only installs client tools on a PC / Laptop.  You need Developer version (or Express) to run a server instance on your laptop.  Workgroup might...

It would seem to me, given the number of columns he's accessing, that he probably has an equivalantly large row/recordset being returned to the view.  In that case, an indexed...

Tracey,

Load is going to be high on Raid 1.  Higher for writing than for reading, because the disks are essentially making two copies of every transaction on the mirror.  Colin...

Are you looking under the Database Engine or did you actually connect via Object Explorer to the Integration Services object?