Question : I ran the following query: SELECT session_id,CASE transaction_isolation_level WHEN 0 THEN ‘Unspecified’ WHEN 1 THEN ‘ReadUncommitted’ WHEN 2 […]

Question : Link: https://www.brentozar.com/archive/2018/10/using-nolock-heres-how-youll-get-the-wrong-query-results/ The article mentions some problems with using NOLOCK: You can see rows twice You can skip […]

Question : I am a Report Developer who wants to make my queries as efficient as possible. I used to […]

  • 1
  • 2