Lock mode RangeI-N

Question

Post reply

Lock mode RangeI-N

Igor Micev

SSC-Dedicated

Points: 33110
More actions
August 1, 2013 at 10:18 pm

#275844

Comments posted to this topic are about the item Lock mode RangeI-N
Igor Micev,My blog: www.igormicev.com
August 2, 2013 at 3:11 am

This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 19 total)

You must be logged in to reply to this topic. Login to reply

Vinay Kumar SSCertifiable Points: 6099 More actions · Answer 1

It's not an easy for me. but i got it correct.

Something new i learn today. Thanks 🙂

Thanks
Vinay Kumar
-----------------------------------------------------------------
Keep Learning - Keep Growing !!!

ashwani24 Ten Centuries Points: 1071 More actions · Answer 2

ashwani24

Ten Centuries

Points: 1071

August 1, 2013 at 11:53 pm

#1638047

These are commonly knows as Range Locks

Raghavendra Mudugal SSChampion Points: 10658 More actions · Answer 3

ashwani24 (8/1/2013)
These are commonly knows as Range Locks

(and If I recall correctly from my memory...) It applies for Serializable Isolation "only"

ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

kapil_kk SSC-Insane Points: 21316 More actions · Answer 4

Danny Ocean (8/1/2013)
It's not an easy for me. but i got it correct.
Something new i learn today. Thanks 🙂

+1

First have to BOl about it before answering 😛

_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

SQL Surfer '66 SSCertifiable Points: 5161 More actions · Answer 5

Stupid font (no offence to the question author). I started looking for RangeL-N. :crazy:

DugyC Hall of Fame Points: 3804 More actions · Answer 6

SQL Surfer '66 (8/2/2013)
Stupid font (no offence to the question author). I started looking for RangeL-N. :crazy:

+1 :doze:

_____________________________________________________________________
[font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]

TomThomson SSC Guru Points: 104773 More actions · Answer 7

Nice to see a question on locking - it would be good if technical internals stuff like this turned up more often in QOTD.

The lesson to be taken from the second reference given in the explanation is "avoid heaps, and really avoid heaps if you need serializable isolation". It's an interesting reference, and does involve I-N range locks, but not terribly relevant to the question. Perhaps a better second reference would be the SQL Server Transaction Locking and Row Versioning Guide which covers locking and versioning in versions from 2005 to 2012, but in fact the 1st reference in the explanation is perfectly adequate on its own.

edit: fix url tag

Tom

Revenant SSC-Forever Points: 42467 More actions · Answer 8

Danny Ocean (8/1/2013)
It's not an easy for me. but i got it correct.
Something new i learn today. Thanks 🙂

+1

Ken SSCoach Points: 17191 More actions · Answer 9

Thanks for the lock question. I'd like to see more of these.

SQLRNNR SSC Guru Points: 281334 More actions · Answer 10

thanks for the question.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

PHYData DBA SSCertifiable Points: 7541 More actions · Answer 11

Nice question igorMi and great explanation. I had not though about these types of locks for a while.

Thomas Abraham SSChampion Points: 10761 More actions · Answer 12

L' Eomot Inversé (8/2/2013)
Nice to see a question on locking - it would be good if technical internals stuff like this turned up more often in QOTD.

+1 - We spent more than a month on locking protocols in our introductory DB class. Not information I use every day. BUT, knowing about it is good foundation information for the rest of what you need to know about databases.

Thanks to OP for question1

[font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
Connect to me on LinkedIn

PChiragS SSCarpal Tunnel Points: 4965 More actions · Answer 13

PChiragS

SSCarpal Tunnel

Points: 4965

August 3, 2013 at 12:12 pm

#1638430

good question..

Thanks..