Hi Andy thanks for the response. I was trying to use this way to ensure the query plan was cached so that hopefully there would be a performance gain. Even...

Hi Edward thanks for your explanation.

In ref : I assume you inferring having the same number of files as disks within your array, rather than a file on each...

I have been told that if you have 3 disks in your raid array it is best for performance to have a database file per disk in your array as then...

Hi thanks for the reply. I have run sp_configure and my min is set at 0 but my max is set at 32. What does this mean and where is...