Home Forums Article Discussions Article Discussions by Author Discuss content posted by Jonathan Kehayias Using SQL Profiler to Resolve Deadlocks in SQL Server RE: Using SQL Profiler to Resolve Deadlocks in SQL Server

  • June 7, 2010 at 11:19 am

    #1177158

    MeltonDBA (6/7/2010)

    So to prevent heavy deadlocking they simply add (NO LOCK) on their SELECT queries since they are reading from a few tables that are consistently being updated or inserted into.

    Cool, I'd be fine with that solution in my scenario. Unfortunately, I don't think you can tell NHibernate to add that hint. (Yet another reason not to use ORM crap.) But some day we'll hopefully get rid of NHibernate.

    Thanks.