Monthly Archives: March 2012

When were your statistics last updated?

Introduced in sql 2005 the following query will tell you the date your statistics were last update for each of indexes of a table…

Posted in Performance Tuning, SQL 2005, SQL 2008 | Leave a comment

Improved EventLogs in Win 2008

Recently at one client location we had numerous unexplained cluster failovers. I had SQL Server and Analysis Services running on the clusters. When analysis was done on the failover, the analysts found that the “FlightRecorder” showed errors immediately before the … Continue reading

Posted in SQL Administration | Leave a comment