Monitoring For Endless Index Defragmenting – November 2015

This is just a bug fix from my last post of this code. I ran into a case where you would not get notified if the only indexes in a database that were being repeatedly defragged had fill factors of 50 or less. I would think this would be a pretty rare case, but it […]

Share

Monitoring For Endless Index Defragmenting – October 2015

This is the first of three big script updates this month, so stay tuned! I’ve written before about how my SQL script evolve over time. Well, the script I just published last month has already been updated. I had been deploying the script on all the SQL Servers I manage, rather than just the handful […]

Share

SQL Requirements For Upgrading To Dynamics GP 2010

We recently upgraded our installation of Great Plains from version 10 to Dynamics GP 2010 and ran into some difficulties with the upgrade hanging. We’re using SQL 2008 R2 as our database back end. Let me first state that I was not involved in this upgrade and it was our vendor who was working with […]

Share