Förra vecka släppte Microsoft CU3 för SQL Server 2008. Den innehåller en hel den fixar…
One of the last remaining antiques of SQL Server is the default value for the configuration item
Cost Threshold for Parallelism
which has remained unchanged since SQL Server 7.0
This is odd because server hardware has certainly changed since 1998
If you think it is time for Microsoft to update the default please read the short article and vote up the following connect item.
https://connect.microsoft.com/SQLServer/feedback/details/3128949
thanks
Stephen