Article ID: 2546901 - View products that this article applies to.
Microsoft distributes Microsoft SQL Server 2008 R2 fixes as one downloadable file. Because the fixes are cumulative, each new release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2008 R2 fix release.
Consider the following scenario:
Note This issue may occur in one of the following situations:
Service pack informationTo resolve this issue, obtain the latest service pack for SQL Server 2008 R2, and then enable the 4134 trace flag.
For more information, click the following article number to view the article in the Microsoft Knowledge Base:
2527041For more information about how to switch on the 4134 trace flag, visit the following MSDN website:
(https://support.microsoft.com/kb/2527041/en-US/ )How to obtain the latest service pack for SQL Server 2008 R2
How to switch on the 4134 trace flag
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
For more information about ranking functions, visit the following MSDN website:
General information about ranking functionsFor more information about parallel query processing, visit the following MSDN website:
General information about parallel query processingFor more information about the max degree of parallelism option, visit the following TechNet website:
General information about the max degree of parallelism option
Article ID: 2546901 - Last Review: July 20, 2011 - Revision: 2.0