Sorry just to clarify this is excel running with a cube as a data source

Hi thanks for the response.

I have three further questions:

1) After the initialisation is done the first time from the BAK file, does the job just add the data from...

Please forgive my stupidity 🙂

No worries. That's good if you do blog this as it should save others from spending hours banging their head against a brick wall!

Also, thank link doesn't work btw?

Here: http://www.belarc.com/free_download.html

Belarc Advisor. It's more for auditing but it shows your license keys as well. Seemed to do the trick and it was lucky because it was the...

I found a solution now. I managed to use a key finder on the VM to find the key of the installed instance. I could then use that to install...

Because a whole new VM is very expensive. Normally with SQL Server you can install many instances with just one license.

If you take a look at this http://msdn.microsoft.com/en-us/library/cc645993.aspx#Scalability...

I don't have a product key. You pay for a virtual machine through monthly billing. When you set up the virtual machine you choose a preinstalled image that already has...

I could but selecting all that data out twice is very slow. The table is 12GB so it would probably take at least a few hours this way. That is...

Anybody???

This looks exactly even though. It has put 20MB in one file and the other 20MB in the other two files. Is this part of the algorithm that SQL Server...

Because in the second case I can just run an ms for each table and rebuild all. That takes 20 seconds to write as opposed to scripting out hundreds of...

Thanks for the answer. I was just using 10 MB/s as an example, our database wouldn't even begin to come close to that.

In terms of what you were saying...

Ok, so if we take my example again where I want to write 10MBs to a table every second, the drive that my log file resides on would have to...

Yes the four separate vhds were grouped together into one logical volume. With this configuration I achieved double the sequential write speed as one disk. Really I just wanted to...