Dear Professionals, I am pretty much concern about locking and deadlocking transaction and I am working on Trading enviornment so I have to more consious about writting stored procedures and make sure transaction doesn't get lock things like that. Anyone can help me out any website through which I can have clear idea about ecommerce application or Online trading application in terms of database locking. Really appreciate for your help..
Wow, that's more than a little bit scary. If you are working on a stock trading app and you don't know about locking I hope my stocks aren't depending on that app:). In any case there is nothing special about a stock app than any other really as the same principles apply. I would recommend the Inside SQL Server 2005 series of books but this one in particular has a section on locks and deadlocks. http://www.amazon.com/Inside-Microsoft%C2%AE-SQL-Server-2005/dp/0735621969 There are also lots of good articles on the web available with a simple Google search. -- Andrew J. Kelly SQL MVP Solid Quality Mentors "Smith" wrote in message news:FAA22663-926C-4849-B546-368A62F4E856@microsoft.com... > Dear Professionals, > > I am pretty much concern about locking and deadlocking transaction and I > am working on Trading enviornment so I have to more consious about > writting stored procedures and make sure transaction doesn't get lock > things like that. Anyone can help me out any website through which I can > have clear idea about ecommerce application or Online trading application > in terms of database locking. > > Really appreciate for your help.. > > >
