All of the data in their system is stored in XML and each XML string is about 25-50K long. There is some indexing but to access it requires creating...
It has 4Gb of memory with the 3Gb switch. The database is about 20Gb. It is a dedicated box with four 3.0Ghz CPUs, not a virtual machine. We have...
Adding/modifying indexes is not an option as that would violate our support agreement. I've asked the question and was specifically told not to go...
Is there a setting that can limit the amount of CPU a single connection can consume in Sql Server 2005? When the CPU on a single connection goes to...
Separate names with a comma.
