Grant Fritchey - Friday, November 30, 2018 10:37 AM
If it's blocking itself is the query going to parallel execution? Check the execution plan to see what's going on with the query.
Hi Grant, Strangely nothing out of ordinary in the exec plan , index seek , clustered index seek keylookup, small db, small row count on the table! Thanks