My comment was directed at an optimally sized/configured SAN. I don't consider a SAN with 512 LUNs to be optimally configured for database throughput. DAS with that many...

Nice site name colin! 😀

I note, however, that your links on the 2005 page end in .mht for URL as opposed to htm. I tried to hit the...

1) You state "started throwing this error" but don't specify an actual error.

2) Sprocs will often run differently than hard-coded statements. With manual executions the query optimizer has explicit...

A bulk insert method will beat individual inserts in most if not all cases. Here you would avoid the network and execution hits in addition. Linchi Shea did...

Hey, thanks for the flattery!! hehehe

You are correct though - seems that a LOT of people out there have misconceptions about sets and ordering.

Stealing my thunder Gila! I already posted on that yesterday at 8:54. 🙂

A trigger based system could work, as could an asynchronous mechanism other than replication as well.

Two points you are missing in the performance equation Colin. With a SAN it isn't just about the disk I/O capability. SANs usually come with large (sometimes many...

The big thing to take into account with NOCOUNT (or read uncommitted isolation level) is the fairly recently (last 18 months or so I believe) discovered situation whereby you can...

I 'believe' the optimizer can choose an allocation unit scan instead of a clustered index scan - which would allow unordered rows returned from your table with a clustered index....

Try running the dbo/nondbo test again where there are objects with the same name owned by the non-dbo user. See if anything is different then.

Be careful Ramesh - I don't believe that 'special' feature of sql server on the UPDATE statement is guaranteed to work in the future. It may also be dependent...

Well, with 2 drives per RAID set you don't have RAID 1+0 - simply RAID 1. You need 4 drives min for RAID 10.

Your setup is reasonable. I...

I must say that I am very happy that people can do things like the triangular join - and sad that Jeff may make less people do it. Lost...

There is a huge amount of variables to the configuration of storage, including but not limited to:

RAID type

number of spindles per RAID set

HBA cache and cache ratio as well as...