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

1

votes

1

answers

961

views

sp_getapplock to wrap a single DML statment

Mar 31 '11 at 01:48 PM ryanitpro 11

locking blocking

0

votes

3

answers

3.9k

views

Is SELECT WITH(UPDLOCK) secure?

Mar 03 '11 at 08:01 AM seregak76 1

locking

1

votes

1

answers

450

views

How to check if a resource is locked?

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

locking

1

votes

2

answers

2.3k

views

Lock waits, SQL server or application?

Jan 04 '11 at 11:56 AM jaga23 11

locking

3

votes

1

answers

742

views

Where does APPLOCK_TEST live?

Nov 18 '10 at 04:44 PM anthonyk 78

locking programming

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

0

votes

0

answers

425

views

Sqlser 2008 Blocking question

Apr 29 '10 at 01:49 PM KumarS 1

sql-server-2008 locking

8

votes

3

answers

2.6k

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

1

votes

1

answers

1.4k

views

SQLCMD Script Is Locking Detached Database Files Objects

Mar 17 '10 at 04:02 PM opnqryf 11

sql-server-2005 database job locking

0

votes

2

answers

486

views

SQL Locking information retrieved after lock as occured and completed

Feb 22 '10 at 05:03 AM Jack Goh 1

sql-server-2008 locking

0

votes

3

answers

1k

views

Locking Issue with Concurrent Access of same stored procedure

Jan 09 '10 at 04:16 AM Aiby 1

sql-server-2000 locking

0

votes

3

answers

1.2k

views

Opening Database properties in SSMS fails with lock

Dec 08 '09 at 11:59 AM sp_lock 8.1k

sql-server ssms locking

0

votes

0

answers

1.3k

views

Page Granularity Locking

Nov 23 '09 at 05:48 AM Kristen ♦ 2.2k

sql-server-2005 shrink-database locking

1

votes

1

answers

996

views

Isolation Levels

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

t-sql transaction locking blocking isolation-level

0

votes

1

answers

883

views

Deadlock Problem With UPDATE

Oct 21 '09 at 10:18 AM graz ♦ 525

sql-server-2005 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 × 1834
sql-server-2008 × 1601
t-sql × 912
sql-server-2000 × 454
sql-server × 272
database × 209
ssms × 118
job × 82
transaction × 51
shrink-database × 33
deadlock × 32
locking × 31
blocking × 22
programming × 18
isolation-level × 13
dirty-read × 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.