Re: How does one set read-uncommitted on the entire DB?
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Wed, 1 Mar 2006 22:50:32 +0000 (UTC)
Robert (robert.j.sipe@xxxxxxxxxx) writes:
Rather than setting by session I would like to configure the DB as read
uncommitted.
You can set the database read-only to eliminate locking entirely.
But else you can't do it, and that is probably a good thing. Dirty reads
is nothing you should engage in as a matter of routine. Maybe you should
review indexing in your database instead.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- Follow-Ups:
- References:
- How does one set read-uncommitted on the entire DB?
- From: Robert
- How does one set read-uncommitted on the entire DB?
- Prev by Date: Re: comma deliminited coloumn
- Next by Date: Re: Use MS SQL Server 2005 Developer version to open MDF file?
- Previous by thread: How does one set read-uncommitted on the entire DB?
- Next by thread: Re: How does one set read-uncommitted on the entire DB?
- Index(es):
Relevant Pages
|
