Hi Anyone knows the difference in performance for a san with 2TB between SATA and FATA for the same number of spindles? Won't Ata increase cpu...
Hi When inserting into a table using fulltextsearch which tracks changes, the index is not searchable until 20-60 seconds afterwards. This is...
We have a data table which contains data with mixed content, so there is '<streetname>' and 'streetname' words in the different rows when searching...
Hi I have a problem with fulltext search on a fail-over cluster. Everything seems to work, i can rebuild, populate etc but when i search i get no...
Hi Does anyone have a good case regarding how much overhead extra discs in raid 1+0 konfiguration ? if 8 disks give 1040 iops, how many iops can be...
Hi I have a customer which needs new hardware for running sql 2000 and later 2005. I have recommended dual dual-core xeon with 2MB L2, however he...
Hi In a production environment occasionaly queries which takes too long occurs. In Profiler the rpc has 753ms cpu, 19000 reads and duration on...
Hi I have an update statement which updates one row in a table. This gives up to approx 1000 writes, i suspect that it is a number of clustered views...
Hello I'm monitoring a raid 1 drive with 2 disks on a SAN. The %Disk Time has a maximum of 877157, why is the number higher than 100?
hi I have a problem with a sql including a udf the sql syntax goes like this select top 100 document.* from document inner join folder on...
Separate names with a comma.
