How to stop table locks and other performance tips | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

How to stop table locks and other performance tips

My clients have databases that are primarily for data analysis. Are there any hints/options that I should use for tables that are read only? I am already using <br />"WITH (NOLOCK)" but I was hoping that there was more. [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />]<br /><br />Thanks<br /><br /><br /><br />Daniel Reber<br />Datamasters, Inc
You can set red only in databas properties, using Enterprise Manager if you want for all tables. Or for each table you can set Select in permission of each user or group. Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
I can’t set read only because I write to some of the tables that are not used for analysis. The tables that are read only ,I already have just select permissions set. Are there any other hints/options that I can use besides "WITH (NOLOCK)"? Thanks
Daniel Reber
Datamasters, Inc
READUNCOMMITTED do the same than NOLOCK. HTH Luis Martin
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.
]]>