ch as a constraint, default, log, rule, and stored procedure. OPTION(MAXDOP 1) at the end of SELECT statement on production. This limits process on a single CPU, and process on other CPU's would not be affected in an event of heavy process is requested. E.g select top 1 * from [TABLE] OPTION(MAXDOP 1) There is no need to add "WITH(NOLOCK)" to all the tables. Add "set transaction isolation level read uncommitted" to the top of the sql. Delete statement: DELETE FROM TABLE FROM TABLE t WITH(NOLOCK) JOIN TABLE1 t1 WITH(NOLOCK) on t.id=t1.id |
|