I wrote it on friday. Didn't use any study guide, company paid for the course.

I took the 431 exam befor the simulations were added, but even comparing to that, the...

Don't know about why they are hanging, but why do you have client tools installed on a server, any why are they been used on the server?

When you create an index, statistics will always be created. The no_recompute affects whether or not the stats will be updated when data changes.

The auto create stats just controls...

What did you set the max to?

Those figures look fine. The only thing I might do with that is to drop SQL's memory slightly so there was more free...

I collected the memory related counters by running sys.dm_os_performance_counters after disabling the 'lock pages in memory' and below are the outputs.

Something odd there. You have buffer cache hit ratio...

Check the following perfmon counters:

Buffer cache hit ratio (should be above 90%)

Pages/sec (The lower the better)

Lazy writes/sec (should be lower than checkpoint. Lazy writer writes pages out due to memory...

If you want a good idea of how many latch waits you're getting, use Performance Monitor. The counters you want are Latches:Average latch wait time, Latches: Latch waits/sec

The average wait...

Is there a terms of usage for this board? I've seen them on other boards. Generally something along the line of 'no profanity, be polite'

Personally, I get very upset when...

Maybe I'm misunderstanding your requirement, but...

SELECT

'Microsoft''s'

Pizza gift cards, movie tickets, cell phone contracts, etc sound nice, but not all of us attending the conference are from the US. An amazon gift voucher on the other hand....

Steve,...

Aah. So close. Good luck for next time

I've written all mine at Prometric. With one exception, I've always had a detailed breakdown (by detailed, I mean 4-8 categories)

The one exception...

The pass mark for these is around 70%, so if the second half was worth more than the first, the failure is understandable. What was your mark, if you don't...

You should have got a print out from the exam center showing you a breakdown of the exam by categories, and a graph for each of those categories showing how well...

In that case, I would leave 1 GB for the OS. This is assuming there's nothing else running on that server. Make sure that the SQL Service account has permission...

Depending on the plan that the optimiser comes up with, SQL may run the cast and filter before it runs the isnumeric filter. Short of plan hints, there's little way...