I have a problem that i can not solv.
The sql query attached have ben used against a sql 2000 without any problem and takes about 7 sec...
Thanks for your answer.
So you think it's best to have the DB's on the raid1.
But on the same harddrive i also have the system and pagefile.
I am setting up a new installation of sql server 2008 on a dell 2950 with 6 disks.
The sqlserver is going to be used of 50 users from a business...
Separate names with a comma.