No arrays, unless you think of a key value pair as a as a one dimensional array.

It looks to me like you are speaking about variable parameter...

You don't have to use huge or very tiny numbers to get lossage with float/real.

They can be very tricky to deal with.

They are NEVER good for amounts that are meant...

Do you guys have a lot of off by one errors in your stored procedures?

If you change it to 4 drives, plus 2 drives @250 each, you have gone overbudget...

We do this manually by restoring the database and logs in standby mode.

That way, you could still run your analysis (as long as it doesn't do anything in the database...

You are correct John.

DBCC shrinkfile NOTRUNCATE does indeed undo the reindex, as you have seen from your investigations.

It moves allocated pages from the end of the file to the beginning...

I am fairly certain that you cannot turn logging on a database off.

However, there are some things you can do.

The preferred way is to use a solid state disk for...

This is because the the "real" datatype is defined as an approximation of the number.

It is usually unnoticable, but very large numbers and very small decimal numbers cannot be represented...