Monthly Archives: August 2013

Duplicate Statistics

The Setup: Standard best practise is to have auto create and auto update statistics set for SQL Server databases. But there is no corresponding setting to remove statistics that are no longer necessary. Unless explicitly managed by the DBA these … Continue reading

Posted in SQL Server | 11 Comments

Quick tip: WMI alerts and SQL Server Agent permissions.

I came across an issue today while trying to create a WMI alert for a mirroring state change. The error was something along the lines of WMI Access denied. Error: 0x80041003. My first port of call was to verify the WMI query … Continue reading

Posted in Security, SQL Server | 3 Comments