Here is the considerable effort you need to put up to download, test and implement cumulative update package and that is announcement from SQL Server Release Services – Cumulative Update 2 for SQL Server 2012 SP1. KBA2790947 talks much about the…

As a DBA parallelism or MAXDOP terms do not need any special introduction, but it is highlgy essential to keep up the necessary settings (default value is 0) on your data platform. In many cases MAXDOP helps to achieve optimization…