So presumably the insert will be unable to complete until the SELECT has release its shared lock on the index

Hi

All interesting replies........

Currently the clustered index is on an identity column and there are no non-clustered index's. There is select, insert and update activity on the table. Neither...

Thanks for the replies guys

Oops I got my columns are rows confused typing.   I meant returns all the columns not all the rows.

The predicates filter...

I came across that but it doesn't apply.  The change tracking is on a 2008 sql server

I think the syscommit table is an in-memory rowstore from this article

Thanks Guys, that's really helpful..

I never like seeing Rtrim and Ltrim. Some Dev's seem to put them into any code by default.

Thanks for the reply.

The linked server is to another SQL box and the script couldn't be simpler.....

SELECT
RTRIM(LTRIM(CONT_REF)) AS CONT_REF,
RTRIM(LTRIM(INITIAL_NUM)) AS INITIAL_NUM,
RTRIM(LTRIM(SECOND_NUM)) AS...