Viewing 15 posts - 2,176 through 2,190 (of 6,036 total)
SQL Kiwi (8/29/2012)
SQL Server can't take row-level IX locks because they don't exist. Intent locks exist to indicate that other locks exist further down the lock hierarchy. Since...
_____________
Code for TallyGenerator
September 6, 2012 at 9:01 pm
Borrowing the DDL and data papulation scripts from dwain.c:
SELECT CA.ItemID, CA.Date
FROM @TableA AS CA
LEFT JOIN @TableB AS B ON CA.ItemID = B.ItemID
LEFT JOIN @TableA AS PA ON...
_____________
Code for TallyGenerator
September 6, 2012 at 8:37 pm
Did you check if the records are actually inserted by SQLCMD run?
_____________
Code for TallyGenerator
August 29, 2012 at 2:53 am
Evil Kraig F (8/28/2012)
Sergiy (8/28/2012)
Evil Kraig F (8/28/2012)
Your constant badgering and attack of the person instead of the issue in question.That's exactly what YOU are doing now.
Quite correct, this conversation...
_____________
Code for TallyGenerator
August 28, 2012 at 10:27 pm
SQL Kiwi (8/28/2012)
Sergiy (8/28/2012)
Please explain why:- X locks applied to RID
- IX locks applied to pages.
What makes then different?
SQL Server can acquire locks at different levels, for example it can...
_____________
Code for TallyGenerator
August 28, 2012 at 9:52 pm
GilaMonster (8/28/2012)
Or you could, you know, go to the link, get the free ebook and read it yourself maybe.
Read the Bible, my son, it has all the answers.
_____________
Code for TallyGenerator
August 28, 2012 at 6:23 pm
Evil Kraig F (8/28/2012)
Your constant badgering and attack of the person instead of the issue in question.
That's exactly what YOU are doing now.
I'd appreciate any example of a personal attack...
_____________
Code for TallyGenerator
August 28, 2012 at 6:22 pm
GilaMonster (8/28/2012)
Or you could, you know, go to the link, get the free ebook and read it yourself maybe.
No answer, I see.
_____________
Code for TallyGenerator
August 28, 2012 at 6:00 pm
Evil Kraig F (8/28/2012)
_____________
Code for TallyGenerator
August 28, 2012 at 5:59 pm
GilaMonster (8/28/2012)
Well I wrote that portion of that chapter, so I guess what's in there would be my explanation.
So, it should be really easy for you to post a relevant...
_____________
Code for TallyGenerator
August 28, 2012 at 5:52 pm
GilaMonster (8/28/2012)
http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/There's a good coverage of locking modes in chapter 6, including why SQL needs IX locks at higher levels.
So, what would be your explanation?
_____________
Code for TallyGenerator
August 28, 2012 at 3:05 pm
GilaMonster (8/28/2012)
(query processor doesn't work with pages, just rows)
Sure?
Ever heard of locks escalation?
_____________
Code for TallyGenerator
August 28, 2012 at 3:04 pm
Now, all together:
Please explain why:
- X locks applied to RID
- IX locks applied to pages.
What makes then different?
_____________
Code for TallyGenerator
August 28, 2012 at 2:52 pm
MissTippsInOz (8/27/2012)I think an update where no update occurs can perhaps being thought of as a logical update. That is, as has already been said, locks are applied in...
_____________
Code for TallyGenerator
August 28, 2012 at 12:30 am
SQL Kiwi (8/26/2012)
Sergiy (8/26/2012)
Was not so clear to me, as it turns out. Learned couple of things here, thanks to the good samaritans.
Good. Well the last (important) thing...
_____________
Code for TallyGenerator
August 27, 2012 at 8:36 pm
Viewing 15 posts - 2,176 through 2,190 (of 6,036 total)