Home Forums SQL Server 2008 SQL Server 2008 - General NOLOCK/Isoloatin Level for READONLY database RE: NOLOCK/Isoloatin Level for READONLY database
pooyan_pdm
Hall of Fame
Points: 3007
More actions
September 18, 2012 at 12:38 pm
#1539229
By setting the DB to readonly no Shared-Lock is requested anymore so there 's a performance benefit in doing that.
and the syntax is so easy
ALTER DATABASE [DB] SET READ_ONLY
Pooyan