Now, I have remarked that creating an index on column 'SOMEDATA' is sufficient to remove the deadlock.
I think an alternate approach would be to commit the insert, then perform the select in a separate transaction. And yet a third way, I believe, would be to set your transaction isolation to a lower level than SERIALIZABLE. But creating an index on the other column seems best, if you are routinely using it in the WHERE clause. thanks, bryan
