The Optimize for Ad Hoc Workloads server configuration can improve performance, and is extremely unlikely to negatively impact performance. This was a new feature that was introduced in SQL Server 2008, and as with many new features in SQL Server, it is not turned on by default. What Optimize for Ad Hoc Workloads Changes. Without the Optimize for Ad Hoc …
Today I participated in my second ever 5K race today, the Bellingham Jingle Bell Run. My running partner (Gypsy the black dog in the picture) accompanied me, and might have increased my speed at a couple of points due to her pulling on the leash. This was as event was a fund raiser for the Arthritis Foundation, which seemed like …
Today I have the pleasure of releasing the next version of the Database Health Monitor application. Currently at version 2.2, I have been working on this since 2011, and I have introduced some new features in the latest version. Visit the Database Health Monitor Download Page to get it for free today. The main page has been updated, with a …