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...
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...
September 6, 2012 at 8:37 pm
Did you check if the records are actually inserted by SQLCMD run?
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...
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...
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.
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...
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.
August 28, 2012 at 6:00 pm
Evil Kraig F (8/28/2012)
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...
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?
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?
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?
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...
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...
August 27, 2012 at 8:36 pm
Viewing 15 posts - 2,176 through 2,190 (of 6,036 total)