Posted by Igor on 04/24/07 10:17

Thanks for you reply's.

I currently use READ UNCOMMITTED only for data that is not important,
like getting lists of referrers or today's top users. But i'm having
problems with my sp for user login, in combination with some other
stored procedures i get deadlocks, don't really know of a way to
resolve those deadlocks other than using NOLOCK on users and
users_online tables.

So generally for that kind of situation where you have to update and
calculate very important data like some money transfers, i should put
REPEATABLE READ or SERIALIZABLE.
One more question, why would one use SERIALIZABLE over REPEATABLE
READ, what are the benefits of SERIALIZABLE?

• Next in forum: Having difficulty setting Back Up to back up file wihout datetime stamp SQL 2K
• Prev in forum: Re: Question about move large amount of data from database to database
• Thread view: Re: READ UNCOMMITTED data

[Reply to this message]