First about index selection where if your WHERE criteria doesn't include the first column in a non-clustered index the server will NOT use the index. i.e.: You search for CustomerID, Customer Last ...
Anyone running a clustered MS SQL setup on top of vSphere? This will be something new for us, but we have a database that can't go down ever. I remember reading about this in passing a couple of years ...