StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
13195221
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
1
CommunityOwnedDate
CreationDate
2012-11-02T12:25:53.827
FavoriteCount
0
LastActivityDate
2017-10-08T20:57:54.667
LastEditDate
2017-10-08T20:57:54.667
LastEditorUserId
472495
OwnerUserId
1794167
ParentId
13192667
PostTypeId
2
Score
2
ViewCount
0
LastEditorDisplayName
text
Body
from my DBA experience with SQL2008, there's very little performance impact for the end user, and the reason is this: The encryption only takes place when writing to, and reading from, to the database file (.DBF) and the backups. Once the data is in memory, it is unencrypted and queries run just as fast as they do normally. The whole encryption process used to be hidious in SQL 2005 and there was a notable performance penalty, but with SQL 2008, the process of encrypting tables or entire databases takes only a few minutes (and the directions are easy to follow - <a href="http://msdn.microsoft.com/en-us/library/cc278098(v=sql.100).aspx" rel="nofollow noreferrer">http://msdn.microsoft.com/en-us/library/cc278098(v=sql.100).aspx</a>). The process basically takes three steps: <ol> <li>create the public/private cert keys (there's a stored procedure for that). </li> <li>turn on the encryption for the db.</li> <li>then save db. </li> </ol> The database being encrypted will switch to single-user mode for a minute or two while the database file is re-written in encrypted form, but it doesn't take long. The conversion of a 50GB file, for instance, takes a couple minutes at the most. Good luck and make sure you don't lose the certificate keys! Email them to yourself, because if you ever need to recover from backup or move the MDF file to another server, you're screwed without the cert files. (Don't worry, it's all spelled out in the MS documentation I listed).
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POIs there a performance difference when we encrypt a database?
 singulars
 PostTypePostTypeId
 PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. UShalfer
UserOwnerUserId
1. USBrian
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
2. VO
 singulars
 PostPostId
 PO
 UserUserId
 This table or related slice is empty.
 VoteTypeVoteTypeId
 VTUpMod
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.