Månedsarkiv: december 2013

Finding missing indexes in SQL Server 2012

This is a nice query using sys.dm_db_missing_index_details, sys.dm_db_missing_index_group_stats and sys.dm_db_missing_index_groups to find out which indexes is missing. SELECT CAST(SERVERPROPERTY(‘ServerName’) AS [nvarchar](256)) AS [SQLServer], db.[database_id] AS [DatabaseID], db.[name] AS [DatabaseName], id.[object_id] AS [ObjectID], id.[statement] AS [FullyQualifiedObjectName], id.[equality_columns] AS [EqualityColumns], id.[inequality_columns] AS … Læs resten

Udgivet i SQL Server - scripts | Kommentarer lukket til Finding missing indexes in SQL Server 2012