In this post I would like to share a CREATE INDEX syntax I was not aware of which I came across a few years ago while moving a multi tera VLDB to a new filegroup. Recently I had to use this syntax again and it took me a few seconds to pull it out of …
SQL Server exposes missing indexes metadata via the following 3 DMVs (Dynamic Management Views) sys.dm_db_missing_index_details, sys.dm_db_missing_index_groups and sys.dm_db_missing_index_group_stats which combined in a simple query return valuable information of indexes that were detected as missing by the Optimizer and logged in those DMVs. The information in these DMVs is updated by the execution of every query …
This is my very first blog post at my own site after over a year of none blogging. What happened is that the site I use to blog at http://blogs.microsoft.co.il/yaniv_etrogi has gone down…. yes, I know…. with tones of my blog posts, I had so many posts just around the Replication features, Partitioning and lots …
Use Powershell to Multi Thread SQL Server Index Maintenance tasks Read More »
