NOTE: THIS ARTICLE ONLY PERTAINS TO V11.2 AND EARLIER. V12.0 and later requires READ_COMMITTED_SNAPSHOT to be ON
Severe performance issues are observed:
Note: The solution provided below should be considered in both cases, with READ_COMMITED_SNAPSHOT ON or OFF