List All Objects and Indexes in a Filegroup or Partition
By Lori Brown | Intermediate , Miscellaneous , SQL Administration , SQL Server
— by Lori Brown @SQLSupahStah One of my clients has a rather large database with multiple filegroups and multiple database files in them. I happened to notice that a specific drive that is occupied by 2 specific files that are supposed to hold indexes is getting utilized at a much higher rate than any of […]
Continue reading