I use amazon.com. I tend to be cautious of any IT book with less than 4 stars.

Gail, can I ask if you passed the exam? I'm assuming you find out there and then as you do with 70-431?

I passed. Got 880. You get the results and...

Have a look in Books online. There's a section on full text search.

Full-Text Search Concepts (ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/fulltxt9/html/db3747e0-db12-4c69-9d81-b5011984eb3a.htm) should get you started.

Have you considered using the fulltext search functionality for this?

With fulltext you probably won't even need the keywords tables. Put a full text index on the documents (assuming they're...

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