Tag Archives: check Where those Index are located

Script to Retrieve Tables, Indexes, Files and File Groups Information

Today, I was working on one of the IO Performance issue. During analysis, I need to figure out index distribution across various Database Files and FileGroups. Thus, My objective is to discover that no Index should be placed on PRIMARY Filegroup. So, I wanted to have information about Indexes which are created on a table [...]