You actually need TWO documents. First is on cluster setup/install/tuning. I believe you can find a very fine example on this sight, written by Brad McGehee?? A...

Hardware can certainly help. I am regularly amazed at how well SQL Server and Windows perform on modern hardware - at least when SQL, databases, code and hardware are...

1) SANS can and do get built with very few spindles (stupidly).

2) SQLIOSIM is for read-write validation as opposed to true benchmarking. For that you should use SQLIO or...

Sorry, but it is my professional opinion that hunting and pecking on this forum will never get you to 5000 hits/sec returning at 0.02 sec max per hit spread across...

Sorry, but my guess is that there isn't enough heavy duty users of varbinary and xml that would be able to give you guidance.

Yes. The issue comes with autofailover, although you will still be getting a mirroring message I think that the primary is offline when the cluster fails over.

Profiler?? What's that?!?! LOL Me, I just stare at the code and intimidate it into performing better! :w00t:

It is amazing the things I have seen over the years fall under the ODAA out clause. :hehe:

On the face of it this is a valid way to provide additional uptime.

Gotta disagree with you on the autoupdate stats being off statement. There are indeed a few huge production systems out there where autoupdate should be disabled, and also warehouse...

Don't think we are crossed. Just that something tickles the back of my head that if you have mirroring set up with a cluster as primary if the cluster...

Grant Fritchey (3/5/2008)

---

FWIW, I put two people through phone screens yesterday. Both had more than 8 years experience in SQL Server. Both were listed as senior level consultants. Neither could...

I think cache pollution may wind up being one of the biggest issues - especially for those not on 2005 SP2.

Sounds like I am definitely among the fortunate here!! I haven't had to deal with a technical interview in over 10 years since I first started consulting. Hell,...

I thought if you do mirroring from a clustered arrangement if the cluster fails over it will cause mirroring to fail over to the secondary, which is undesired. I...