I'm with Gail 100%, full-on study is the only way through this.

According to Microsoft's site, 60% pass the lab first time, with 80% passing the second time.

The MCM page specifically...

If your sprocs really are huge, consider trying to break them down into sub-sprocs or functions (performance allowing, of course).

Analyse your code and see if there are any areas where...

Ideally you want two LAN connections - a "public" connection, which connects the servers to your principal network, and a "private" connection, which purely connects the two (or three, if...

Could it be a RAM issue? If you only have a small amount of RAM you may be experiencing swap-outs to disk which could affect time-outs etc. Is there anything...

I would advise buying a general purpose SQL 2008 administration book and using the 70-432 study guide.

I have a guide to the administration exams being published here in the next...

I think your issue is the use of local system accounts - ideally you should be using domain accounts. If you are not using domain accounts you need to use...

You must take the Knowledge exam first, then the lab.

This link gives you the topics covered:

http://www.microsoft.com/learning/en/us/certification/master-sql-path.aspx

I would assume the Knowledge exam incorporates subjects from both the development and DBA exams,...

No worries, I'll try to make things clearer next time. Cheers!

Hi club

I take your points on board. But without a full picture of the specifications available etc it's difficult to give a detailed recommendation. RAID 1 is a good catch-all...

Yes, RAID 1 for all system databases.

Give special consideration to tempdb - ideally this will be on the fastest disks you can buy. If this can go on separate RAID...

Hi there

I'd recommend RAID 1 - the mirroring will give you failover and won't affect read/write performance.

Mike.

Hi Zaty

What type of mirroring do you have set up? High performance (asynchronous) or high availability (synchronous)?

Obviously if both boxes are rebooting the database will not be available. Mirroring should...

As somebody else said earlier, if you are waking up and dreading going to work it is definitely time to leave. I've had this twice and as soon as it...

Thanks for the link opc, it's an interesting read.

I tend to agree that XML is probably the way to go, just wanted to throw in an alternative.

As usual, the...

I want to back up BitBucket. We all make mistakes - and let's face it, if it wasn't for Steve and a couple of others this site would not even...