sql server blocking because of lack of nolock hints

Topics: Troubleshooting
Jun 1, 2011 at 4:08 PM

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