You can try Symmetric Key Encryption since you are using it in warehouse. Symmetric key is good in performance.

Refer this article,

http://blogs.technet.com/keithcombs/archive/2005/11/24/415079.aspx