Good to know, thanks Brad

The Sams books rock!

Microsoft SQL Server 2008 Management and Administration has more useful multi-instance failover cluster info on one page then the Mc Graw Hil book

I really like my

Microsoft SQL...

This book is worthless, complete waste of paper.

It's nothing but the msdn doc's rephrased. There's nothing...

Thanks David,

The mulit-instance / single-instance terminology does make more sense.

I'm considering these two books

Microsoft SQL Server High Availability (Paperback)

http://www.amazon.com/Microsoft-SQL-Server-High-Availability/dp/0672326256/ref=sr_1_11?ie=UTF8&s=books&qid=1265066982&sr=8-11

Microsoft SQL Server 2008 High Availability with Clustering & Database Mirroring...

Thanks David, my MS contact told me 30days...60 sounds better to me though!

Thanks they are using the integrated full-text in sql 2008

this also appears to be undocumented exec sp_fulltext_service 'fdhost_tracing', 1

Microsoft Connect feedback opened

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=526343

sqlservercentral topic on undocumented trace flags

http://www.sqlservercentral.com/Forums/Topic851463-391-1.aspx

per this article

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=331062

I'm researching the following trace flags which seem to be undocumented

7601, 7603, 7604 and 7605

This also looks promising

http://technet.microsoft.com/en-us/library/cc721269.aspx

Well I chatted with MS support. Waiting for a call back on my support ticket...

Thanks Gail,

Is that Index space usage useful at all?

Per the article I referenced you may want to check your statistics too

you may find this helpful https://blogs.msdn.com/jimmymay/archive/2008/11/28/case-study-part-1-cxpacket-wait-stats-max-degree-of-parallelism-option-introduction-to-using-wait-stats-to-identify-remediate-query-parallelism-bottlenecks.aspx

I'd recommend setting up some look-up tables for normalization purposes.

for example a relationships table

1 - brother

2 - sister

3 - 2nd cousin twice removed

etc.

Then in your base table where your wiring...