Query Tuning Essentials: What Forces SQL Server Queries To Run Single Threaded?
Going Further
If this is the kind of SQL Server stuff you love learning about, you’ll love my training. I’m offering a 75% discount to my blog readers if you click from here. I’m also available for consulting if you just don’t have time for that, and need to solve database performance problems quickly. You can also get a quick, low cost health check with no phone time required.
Related Posts
- Why Read Committed Queries Can Still Return Bad Results In SQL Server
- Join Me And Kendra Little At PASS For Two Days Of SQL Server Performance Tuning Precons
- Updates To sp_QuickieStore, sp_HumanEventsBlockViewer, and sp_PressureDetector
- Join me In Boston May 10 For A Full Day Of SQL Server Performance Tuning Training
Would also add that prior to 2019, UDFs on computed columns prevent queries from going parallel, even if you don’t reference the column in your query!
(Sorry if you covered this and I missed it!).
Yep, I cover that. Also, UDF inlining doesn’t fix that issue at all. It’s explicitly called out in the documentation.