Azure has announced the new "D" series of VM's where the temporary drive resides on a SSD
I was planning to use this as the tempDB, it should speed up SQL somewhat with faster temoDB access. However,data on this drive may be lost at any reboot.
In such a situation, how does SQL deal with the loss? Is this supported behavior?