tag:blogger.com,1999:blog-5003807027724289640.post3281861969649564550..comments2024-03-29T00:18:08.094-07:00Comments on D. Patrick Caldwell on Software Engineering: Column Encryption in SQL Server 2008 with Symmetric KeysD. Patrick Caldwellhttp://www.blogger.com/profile/09236952464473670820noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-5003807027724289640.post-79318999384187062072013-07-14T10:49:34.049-07:002013-07-14T10:49:34.049-07:00nice
souvenir pernikahan
undangan pernikahan
souve...nice<br /><a href="http://www.souvenirku182.blogspot.com/" title="souvenir pernikahan" rel="nofollow">souvenir pernikahan</a><br /><a href="http://www.souvenirku182.blogspot.com/" title="undangan pernikahan" rel="nofollow">undangan pernikahan</a><br /><a href="http://www.souvenirku182.blogspot.com/" title="souvenir pernikahan murah" rel="nofollow">souvenir pernikahan murah</a><br /><a href="http://4qbonk.blogspot.com/" rel="nofollow">Panduan Teknisi Komputer</a><br /><a href="http://rental-fotocopy.com/" rel="nofollow">Fotocopy</a><br /><a href="http://zaid-info.blogspot.com/" rel="nofollow">Zaid</a><br />muzazuhttps://www.blogger.com/profile/06321535849171176076noreply@blogger.comtag:blogger.com,1999:blog-5003807027724289640.post-35988206694459962802011-09-13T11:22:34.206-07:002011-09-13T11:22:34.206-07:00Hey Oliver,
You can do a select and use the decry...Hey Oliver,<br /><br />You can do a select and use the decrypted values in a where clause, but you'll find the performance is much worse than desirable as there's no way to take advantage of indexing when scanning for particular values. It's also quite painful when joining (though it's pretty easy to avoid the need to join on your encrypted values).<br /><br />I have a follow up to this post that discusses using something similar to a hash table to speed up query times.<br /><br /><a href="http://dpatrickcaldwell.blogspot.com/2010/10/sql-server-encrypted-columns.html" rel="nofollow">Improving Search Performance when using SQL Server 2008 Encrypted Columns</a><br /><br />Thanks for the comment,<br />PatrickD. Patrick Caldwellhttps://www.blogger.com/profile/09236952464473670820noreply@blogger.comtag:blogger.com,1999:blog-5003807027724289640.post-60483746313059060722011-09-13T10:49:59.854-07:002011-09-13T10:49:59.854-07:00...but how does SQL Server find an entry when it&#......but how does SQL Server find an entry when it's encrypted? Can you do SELECT statements?Anonymousnoreply@blogger.com