Last month in June, I wrote about capping SQL Server's memory so that it does not use up all available memory. You can read about it here . In this blog, I want to look at another setting in SQL Server, and that setting is the Max Degree of Parallelism…