Thanks Andy for the good explination.

I will check with the vendor to see if min of 4096 and a MAX 8192 will be ok for SQL. That...

Thanks for all the replys, the move was successfull.

Yes, even though we are just physically moving the server "as is" we will have a backup of the server file systems and databases.

Hi, thank you for the quick reply.

What do you mean by drives "presented the same way as today"?

Do you mean C, D, E and F? And/or with volume name...

Thanks for the quick reply and heads up on the PASS summit. I forgot about the summit.

Thank you.

How do we install it and what service pack for Analysis Services do we need to be at to be compatible with SQL 2005 SP2 (3042).

So changing it on one server is enough?

Cluster is set up as failover.

It is the database file NOT the log file that has the space growing.

The log file is empty, but I see over 1GB of space used in the...

When I ran it in Full recovery the log file had to expand 2 x.

I am really concerned about getting this table to perform better but the apparent...

Thank you David. Yes it does make sense. I need to focus on the business impact and also present a reasonable response time to create the indexes for...

I may soon be in the position to justify why we (IT) should be the only one to create and drop indexes on our Data Repository. We have the...

Thank you for the confirmation.

I as DBA do those requests now. There is another group in the organization (non-IT) that has their own server that is linked to the Data Repository server. ...

Mixing environments has never sat well with me either. We do intend to use SQL Mail (or some better way to get notifications on data loads, backups and...