Questions in topic: locking - SQL Server Q&A from the SQL Server Central community

x

login about faq Site discussion (meta-askssc)

Questions in topic: locking

8

votes

3

answers

2.7k

views

Use of SQL NOLOCK hint in the select query. Yes or NO.

Mar 26 '10 at 04:00 AM Rob Farley 5.7k

t-sql locking

5

votes

5

answers

2.1k

views

Lock Table, When Disabling, On Delete Triggers

May 17 '11 at 03:58 AM DeDogs 53

trigger table delete locking disabled

5

votes

1

answers

342

views

Mass blocking for no reason

Oct 02 '12 at 07:23 PM sp_lock 8.1k

sql-server-2008-r2 locking blocking

3

votes

4

answers

1.9k

views

When is the risk of a dirty read acceptable?

Aug 20 '10 at 12:50 PM TimothyAWiseman 14.3k

locking blocking isolation-level dirty-read

3

votes

1

answers

745

views

Where does APPLOCK_TEST live?

Nov 18 '10 at 04:44 PM anthonyk 78

locking programming

2

votes

1

answers

229

views

Locking, parallel reads

Jun 08 '12 at 01:46 PM Usman Butt 13.8k

locking

1

votes

1

answers

1k

views

Isolation Levels

Nov 18 '09 at 02:35 PM Tom Staab 5.8k

t-sql transaction locking blocking isolation-level

1

votes

1

answers

799

views

Please advise on why this deadlock and slowness problem happens?

Oct 12 '09 at 04:26 PM graz ♦ 525

sql-server-2005 locking

1

votes

1

answers

1.5k

views

SQLCMD Script Is Locking Detached Database Files Objects

Mar 17 '10 at 04:02 PM opnqryf 11

sql-server-2005 database job locking

1

votes

2

answers

2.4k

views

Lock waits, SQL server or application?

Jan 04 '11 at 11:56 AM jaga23 11

locking

1

votes

1

answers

456

views

How to check if a resource is locked?

Mar 02 '11 at 04:57 AM Kev Riley ♦♦ 46.1k

locking

1

votes

1

answers

967

views

sp_getapplock to wrap a single DML statment

Mar 31 '11 at 01:48 PM ryanitpro 11

locking blocking

1

votes

1

answers

1.3k

views

SQL Server 2005 Locking Escalation Problem?

May 24 '11 at 10:12 AM KenJ 12.4k

sql-server-2005 locking

1

votes

2

answers

1.1k

views

CREATE FUNCTION executes during the UPDATE statement?

Jun 21 '11 at 06:30 AM Tatyana 413

locking function create

1

votes

4

answers

1.3k

views

Deadlock issue, which option shall I use?

Jun 30 '11 at 09:19 AM Leo 1.6k

sql-server-2008 deadlock locking

31 questions

57answers

Follow @Ask_SSC

Follow Ask SSC on Facebook

Find Ask SSC on Google+

Find us on LinkedIn

Tags

sql-server-2005 × 1835
sql-server-2008 × 1601
t-sql × 914
sql-server-2008-r2 × 394
database × 210
trigger × 98
job × 83
table × 76
transaction × 51
delete × 43
deadlock × 32
locking × 31
blocking × 22
programming × 18
isolation-level × 13
function × 12
create × 11
dirty-read × 3
disabled × 3

posts per page 15 30 50

Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.