SQL Server has some settings which sound like a great idea but can cause major problems for performance and availability when used improperly. This video takes you on a tour of SQL Server’s most dangerous settings, from priority boost to lightweight pooling.
[youtube CsEsOO6EPNw]
Video Producer: http://www.brentozar.com/