Subscribe to this blog
Archives: October 2011
More Denali Execution Plan Warning Goodies
In my last blog, I showed how the execution plan in denali has been enhanced by 2 new warnings ,conversion affecting cardinality and conversion affecting seek, which are shown when a data type conversion has happened either implicitly or explicitly.
That is not all though, there is more . Also… Read more
0 comments, 337 reads
Posted in Dave Ballantynes blog on 19 October 2011
Implicit Conversions warning
After adding an index, ensuring that an index is actually used is probably the biggest win you will get in terms of performance in SqlServer. There are many ways that an query can be non-sargable, and therefore not using an available index, a common one is implicit (or even explicit)… Read more
1 comments, 358 reads
Posted in Dave Ballantynes blog on 17 October 2011