Madeira TeamJan 22, 20151 minIndex Usage StatisticsView index usage statistics that show you how often the indexes in the database are used, and whether they’re used for writing or...
Madeira TeamNov 3, 20141 minAuto Indexes REBUILD and REORGANIZEIf your database needs a complete index overhaul, you can do it automatically. This useful script rebuilds or reorganizes indexes...
Madeira TeamSep 3, 20141 minQuery Stats scriptThis query stats script returns aggregated statistics information for every query statement in the cached plan. Use it to get details on...
Madeira TeamNov 6, 20126 minCompression – Much more than saving spaceI remember when SQL server 2008 was first released and I have examined some of its features, when I came across Compression, I was very...