Top "Nolock" questions

A SQL Server table hint that can be used to prevent queries from issuing shared read locks.

What is "with (nolock)" in SQL Server?

Can someone explain the implications of using with (nolock) on queries, when you should/shouldn't use it? For example, if …

sql-server nolock
SQL Server NOLOCK and joins

Background: I have a performance-critical query I'd like to run and I don't care about dirty reads. My question is; …

sql sql-server nolock
Is the NOLOCK (Sql Server hint) bad practice?

I'm in the business of making website and applications that are not mission critical -> eg. banking software, space …

sql sql-server tsql sql-server-2008 nolock
syntax for nolock in sql

I have seen sql statements using nolock and with(nolock) e.g - select * from table1 nolock where column1 > 10 …

sql-server syntax nolock
Remote table-Valued Function Calls are not allowed

How can I make this work?Im running a table valued function from a remote linked server. i tried adding …

sql sql-server user-defined-functions nolock
PostgreSQL Equivalent of SQLServer's NoLock Hint

In SQLServer, you can use syntax "(nolock)" to ensure the query doesn't lock the table or isn't blocked by other …

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

Everything is based on the assumption that with(nolock) is entirely appropriate for the situtation. There are already plenty of …

sql sql-server select sql-server-2008-r2 nolock
What is purpose of using NOLOCK on a SELECT statement?

Can anyone suggest a good reason to issue a NOLOCK on a SELECT statement? I am re-factoring some stored procedures …

sql select nolock
Update Query with Nolock hint

I am trying to put an with(NOLOCK) on an update query: UPDATE pth_patchLookup with(nolock) SET ScanDateTime = Getdate() …

sql sql-server-2008-r2 nolock
Java Hibernate HQL queries with nolock

Is there a way to run these queries as if I added a (NOLOCK) hint to them?

java hibernate orm nolock