StackOverflow Questions for Tag: nolock

Amol Patil

Reputation: 1005

SQL SERVER, will select query with (TABLOCKX) faster than with(NOLOCK) or vice versa?

sql-servert-sqllockingnolock

Score: 0

Answers: 2

Elan

Reputation: 6376

How can I avoid a deadlock between these two SQL statements?

sqldeadlocksql-server-2005-expressnolock

Score: 5

Answers: 3

Cheri Choc

Reputation: 141

using 'with nolock' in transaction or when dropping table

sqltransactionstruncatenolock

Score: 1

Answers: 1

Joshua Glickman

Reputation: 35

JPA sql server 'nolock' without transaction

sql-serverjpanolock

Score: 2

Answers: 0

Jiri Necas

Reputation: 63

Do I get any performance gain by using WITH (NOLOCK) on SQL Server database where READ_COMMITTED_SNAPSHOT is switched on?

sql-servernolocksnapshot-isolation

Score: 3

Answers: 3

AntDC

Reputation: 1917

Using WITH (NOLOCK) on some tables in a JOIN query

sql-serverisolation-levelnolock

Score: 0

Answers: 1

eiu165

Reputation: 6271

Read uncommitted when using Rob Conery's Massive

isolation-levelmassivenolockread-uncommitted

Score: 0

Answers: 1

Catalin Lupuleti

Reputation: 37

SELECT WITH (NOLOCK) sometimes returns no results

sqlsql-servernolock

Score: -1

Answers: 1

Dmitry Stepanov

Reputation: 2924

TransactionScope in business layer for dirty async read

c#transactionstransactionscopenolock

Score: 1

Answers: 1

Chris

Reputation: 2303

Using WITH(NOLOCK) to increase performance

performancesql-server-2005nolock

Score: 1

Answers: 3

Beannie

Reputation: 79

dapper-extensions GetList() with (nolock)

sql-serverdapperdapper-extensionsnolock

Score: 5

Answers: 1

supergrady

Reputation: 1322

Deadlock between select WITH (NOLOCK) and replication agent

sqlsql-serverdeadlockdatabase-replicationnolock

Score: 1

Answers: 0

arjuncc

Reputation: 3297

modifying existing code to adapt nolock in jpa

javasql-serverhibernatejpanolock

Score: 1

Answers: 0

seenasan

Reputation: 221

syntax for nolock in sql

sql-serversyntaxnolock

Score: 22

Answers: 5

anonymous1110

Reputation: 885

Remote table-Valued Function Calls are not allowed

sqlsql-serveruser-defined-functionsnolock

Score: 38

Answers: 6

DanP

Reputation: 6478

SQL Server NOLOCK and joins

sqlsql-servernolock

Score: 192

Answers: 3

Joe McCarty

Reputation: 145

Temp Variable Assignment WITH (NOLOCK)

sqlt-sqlvariablesnolock

Score: 1

Answers: 0

UnDiUdin

Reputation: 15394

WTH (NOLOCK) syntax fo subquery

sql-serversql-server-2008-r2nolock

Score: 5

Answers: 3

Biscuit128

Reputation: 5408

Bad SQL grammar with statements using NOLOCK using HSQLDB

sqlhsqldbnolock

Score: 0

Answers: 1

Rob

Reputation: 874

with(nolock) or (nolock) - Is there a difference?

sqlsql-serverselectsql-server-2008-r2nolock

Score: 56

Answers: 3

PreviousPage 2Next

StackOverflow Questions for Tag: nolock

SQL SERVER, will select query with (TABLOCKX) faster than with(NOLOCK) or vice versa?

How can I avoid a deadlock between these two SQL statements?

using &#39;with nolock&#39; in transaction or when dropping table

JPA sql server &#39;nolock&#39; without transaction

Do I get any performance gain by using WITH (NOLOCK) on SQL Server database where READ_COMMITTED_SNAPSHOT is switched on?

Using WITH (NOLOCK) on some tables in a JOIN query

Read uncommitted when using Rob Conery&#39;s Massive

SELECT WITH (NOLOCK) sometimes returns no results

TransactionScope in business layer for dirty async read

Using WITH(NOLOCK) to increase performance

dapper-extensions GetList() with (nolock)

Deadlock between select WITH (NOLOCK) and replication agent

modifying existing code to adapt nolock in jpa

syntax for nolock in sql

Remote table-Valued Function Calls are not allowed

SQL Server NOLOCK and joins

Temp Variable Assignment WITH (NOLOCK)

WTH (NOLOCK) syntax fo subquery

Bad SQL grammar with statements using NOLOCK using HSQLDB

with(nolock) or (nolock) - Is there a difference?

using 'with nolock' in transaction or when dropping table

JPA sql server 'nolock' without transaction

Read uncommitted when using Rob Conery's Massive