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

0

votes

1

answers

51

views

SQL DB locking

May 14 at 04:57 PM Grant Fritchey ♦♦ 62.7k

sql-server-2008-r2 stored-procedures database-design maintenance 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

0

votes

3

answers

1.3k

views

Opening Database properties in SSMS fails with lock

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

sql-server ssms 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

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

1

votes

1

answers

803

views

Please advise on why this deadlock and slowness problem happens?

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

sql-server-2005 locking

0

votes

1

answers

892

views

Deadlock Problem With UPDATE

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

sql-server-2005 deadlock 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

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

2

answers

493

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

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

0

votes

0

answers

435

views

Sqlser 2008 Blocking question

Apr 29 '10 at 01:49 PM KumarS 1

sql-server-2008 locking

3

votes

1

answers

751

views

Where does APPLOCK_TEST live?

Nov 18 '10 at 04:44 PM anthonyk 78

locking programming

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

458

views

How to check if a resource is locked?

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

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 × 1602
t-sql × 914
sql-server-2000 × 454
sql-server-2008-r2 × 394
stored-procedures × 340
sql-server × 272
database × 210
ssms × 118
database-design × 107
job × 83
transaction × 51
maintenance × 33
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.