A good while ago I was asked if it was possible to consistently produce a parallel plan by Tom LaRock(blog/twitter), and I recalled from reading Grant Fritchey’s(blog/twitter) book on Execution Plans that it was possible to do this by adjusting the ‘cost threshold for parallelism’ sp_configure option from the default of five to a value [...]
Jonathan Kehayias
The Rambling DBA
Tuning ‘cost threshold for parallelism’ from the Plan Cache
Posted on: January 19, 2010 10:19 am
Finding Implicit Column Conversions in the Plan Cache
Posted on: January 8, 2010 1:54 pm
Last year Tibor Karaszi posted a blog post titled Match Those Types that talked about implicit data type conversions associated with mismatched data types between filter criteria and table column data types. His blog post does a good job of covering the topic so I am not going to rehash it out here. However, at [...]
