Change server Cost Threshold for Parallelism (CTFP)

Introduction

Problem

We need to change the CTFP default to the best known value.

Solution

https://github.com/steverezhener/DBA/blob/master/Procedures/bestpractices.usp_change_server_cost_threshold_for_parallelism.sql

Example

Based on https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-cost-threshold-for-parallelism-server-configuration-option