Nice question.

I had heard about this feature request for SQL Server Logins and DB Users being seperated back when 2005 was a Beta.

I wonder if there is any current information on the following questions:

*How does a High Volume Transactional (at least over 200 batches per minute with 100 updates and 50 inserts per minute) database perform when the users accounts are all Contained? Does that change with

* How does the security context switching work to limit user access in the contained DB with contained users vs users with SQL Logins?

* Will a SQL Login automaticly win a resource lock conflict with a contained user?