Latest Contributions by AnthroSys

Good morning, I am wondering if you captured any sort of tracing that might help explain why the performance is better with the higher database compatibility setting. Often Microsoft will tie optimizer and other general improvements to the compatibility level so what you are seeing could be related to that, but it does peak my curiosity about what queries are actually being affected. It is always good to update the compat level though, whenever you upgrade SQL Server.  ... View more