Thanks, a blindingly obvious solution, only you need to know about it. I didn't know you could filter the index because the last time I REALLY looked at an index,...

Just noticed your by-line ...for "Row-By-Agonizing-Row"

Don't you just "curse OR" rant when that happens?:-)

I certainly am not arguing with Phil, or the two posters. Maybe I'm just frustrated with some deadlock investigations where neither transaction was doing anything wrong, and if both had...

Tom.Thomson (8/30/2011)

---

... Whether the depths are the same or different depends on the number of rows so far inserted, and since A is small they usually be the same...

I understand a page is 8000 bytes (close to but less than 8KB, close enough to call it 8k) and it reads pages to get the information from the DB,...

A big deal was made that a B+ tree isn't anything like a binary tree, so it isn't a modified binary tree.

1. A binary tree is a method of...

Tom.Thomson (8/27/2011)

---

It's an interesting editorial. An some interesting comments - some people seem to be assuming that the clustered index must be unique, or that the primary key io...

OK, in my case there was a tinyint field, in the entire table, and that field had only one value. I know what that value is. The second field was...

GilaMonster (8/28/2011...

If it is defined as the first column of the primary key, then it is the leading column of the index key. Order of columns in an index key...

It sounds like you are getting hit with conversion of string in VB to Decimal in SQL as a problem.

Executing:

declare @val varchar(20) = '-83.911', @bval DECIMAL(20,15)

set @bval=@val

select @bval,...

I agree that all fields in the index are stored in the index binary tree structure, in fact, I believed that when I set up the primary key of the...

Great, I replied to a newbie and the engine goes to the end of the queue.

Your query does make sense, but because you are new, you didn't realize this is not a deadlock situation, it is a blocking situation. In order for a deadlock to...

In this example you imply both queries are locked by the other in the first set of queries. The first query has achieved all the locks needed to complete the...

Craig Farrell (3/21/2011)

---

It's a lot of work to try to get on top of everything going on, ... You have to deduce and guess at what business really wanted,...