Introduced in sql 2005 the following query will tell you the date your statistics were last update for each of indexes of a table… Continue reading “When were your statistics last updated?”
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 failover. The Flight Recorder got the blame for the failover. When i was brought in, i took a closer look at the log and i noted serveral things: Continue reading “Improved EventLogs in Win 2008”