some select statements are causing sql command timeouts due to blocking. i'm frankly astounded at why nolock hints would not be used.
any ideas on how to fix this? do i really have to churn through the code and add them myself?
here's an example:
SELECT commonpart0_.Id as Id717_0_, commonpart0_.CreatedUtc as CreatedUtc717_0_, commonpart0_.PublishedUtc as Publishe3_717_0_,
commonpart0_.ModifiedUtc as Modified4_717_0_, commonpart0_.ContentItemRecord_id as ContentI5717_0
FROM hsn_Common_CommonPartVersionRecord commonpart0_ WHERE commonpart0_.Id=@p0