Optimize ASP.NET Membership Stored Procedures for greater speed and sc

ASP.NET Membership stored proc are not fine tuned for high load. So, under heavy load - the major tables like aspnet_Users and aspnet_Membership produces lock contention and transaction deadlocks. Learn how to solve this.