Following are some tit bits about TDE in SQL Server 2008: Instant file initialization is disabled for all encrypted databases so page headers are in a known state and the file does not include stray bits off the disk Tempdb is encrypted if there are any Read More...