William Plourde (2/1/2013)
ok, I think I understand that. So if fetching the 'common' un enc data just make sure I use the appropriate field list in the query. And if I need all the data just go for it.So how do others do this out there in the world ? Do people commonly encrypt individual columns in a table or just say the heck with it and encrypt the entire table ?
You will always have some unencrypted columns is a table, like the primary key and any indexed columns. Indexes on an indexed column are worthless.
Encrypt only data that needs to be encrypted.