De curand am citit cartea "SQL Server™ 2005 Bible", scrisa de Paul Nielsen. La capitolul "Managing Transactions, Locking and Blocking" am intalnit urmatoarea informatie legata de proceduri stocate si shared locks. :
    "Be careful with shared locks. I believe that misused shared locks are a common cause of
    update-performance problems. Applications should grab the data in a way that doesn’t hold
    the shared lock. This is one compelling reason to use stored procedures to retrieve data."

Cum influenteaza procedurile stocate felul cum se obtine un shared lock? De ce acest lucru nu se intampla si la view-uri?