• Vedran Kesegic (3/26/2013)


    Heap should have no indexes. Try with TABLOCKX hint.

    Hi Vedran,

    I couldn't quite connect your two sentences:

    "Heaps should have no indexes" (heaps can have non clustered indexes, can't they?),

    and

    "Try with TABLOCKX hint".

    Nevertheless, I did try TABLOCKX to no avail.