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-Microso.../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" <naissani (AT) hotmail (DOT) co> wrote

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-Microso.../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" <naissani (AT) hotmail (DOT) co> wrote

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-Microso.../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" <naissani (AT) hotmail (DOT) co> wrote

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-Microso.../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" <naissani (AT) hotmail (DOT) co> wrote

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-Microso.../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" <naissani (AT) hotmail (DOT) co> wrote

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-Microso.../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" <naissani (AT) hotmail (DOT) co> wrote

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-Microso.../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" <naissani (AT) hotmail (DOT) co> wrote

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-Microso.../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" <naissani (AT) hotmail (DOT) co> wrote

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-Microso.../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" <naissani (AT) hotmail (DOT) co> wrote