Unfortunately I do not have RAID driver.

Only a simple hard disk drive.

As far as I understand, I should first partition my HDD and then install Windows 2008. If so, how...

Is there any method to distribute the load on servers?

my servers are a principal sever and a mirror for it.

it seems to be an smart solution,

however even a small chance of blocking will be destructive to my app.

can I distribute the load on two or more servers?

because of importance...

If it helps, values of colY can be in the range of [0-100] or [1-100].

But as said, colY is random in nature and can not be used as an index.

It...

values of Y column are random and I do not want to make an index on them.

I would think that compression will slow it down. Isn't so?

"inserting new values could...

X is a BIGINT. It is also the primary key of the table.

Y is a REAL value.

About 200 new records will be INSERTed into the table per second.

So, after one...