Can we use partitioning on encrypted database?

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Eric M Russell SSC Guru Points: 125561 More actions · Answer 1

Table Partitioning, TDE, and page compression can all work in conjunction.

"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 2

As Eric mentioned, yes. TDE is the entire database, all the mdf/ndf files. Partitioning fits within here, so this works fine.

Almighty SSCrazy Points: 2001 More actions · Answer 3

SSCrazy

Points: 2001

August 15, 2016 at 12:35 am

Thanks folks ..