SQL Server Performance Office Hours Episode 34 Questions: * Why do parallel batch mode sorts only utilize 1 thread? * With all of the recent content frequently mentioning no locks and read uncommitted isolation level, Is there ever a situation that you would recommend using nolock or is it always avoidable? * What’s required for […] The post SQL Server Performance Office Hours Episode 34 appeared first on Darling Data.