Madeira TeamMar 3, 20151 minHow to Fix Latch Problems when Working with Ascending Keys in SQL ServerTraditionally, we want our Clustered Index to have the following attributes: Narrow: So that our clustered index and the non-clustered...
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 20, 20141 minThe Truth About Index FragmentationIn just a little while, I’m going to give a presentation at the PASS Performance Virtual Chapter. You can download the materials from my...
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 30, 20122 minSmall Changes Can Make A World Of DifferenceSQL Server 2012 is best known for its bombastic new features: AlwaysOn, Columnstore indexes, Window functions enhancements, Extended...