MY thinking ...TDE should not implement on all databases, I am thinking TDE will be more useful for One DB (say HR Database) on a server.

Found some more flaws...

Thanks Robert. Can you please explain little bit more why we need to save it in a Source control?

Well ...

I found some points here ...

1. Since both the nodes share one Disk, we need to create one cert and one key for both the nodes and save with...

Hi

You can process (or ) check the dimensions first and then start processing partitions. If that doesn't work for you check the SQL behind the partition.

HI

If you think the DB is not much in use by other processes, go head for it.

old hand

do not restart the SQL services, it will be much worse cause database may turn into recovery mode.

thats dangerous move.

Hi

In my perspective roll backs may take 75% more time(If you kill after 1 hr, it will take at least 1hr 45mins to roll back), to end the transaction....

Here You go, this may help you.

http://www.sqlservercentral.com/articles/usingodsasamiddlelayer/2346/