1
kudos
spam Kudos Remove

Move non clustered indexes to a new filegroup « Data Realized – The Blog

published 1028 days, 9 hours, 45 minutes ago posted by http://datarealized.wordpress.com/http://datarealized.wordpress.com/ 1031 days, 6 hours, 17 minutes ago
Thursday, July 30, 2009 12:07:16 PM GMT Monday, July 27, 2009 3:35:22 PM GMT

So, over the years I have needed to move an index or a set of indexes to a new or different file group. I’ve written scripts for this in the past and lost them along the way and I couldn’t find anything out there on the bing or google interwebs. The concept of multiple files and file groups for a database is beginning to sink in with a lot of developers and dba’s. The rationale for using them is typically sound and in my experience it’s one of wanting to decrease the internal file fragmentation of the d...

category: Analysis | clicked: 9 | | source: datarealized.wordpress.com | show counter code
tags: file groups, index management, SQL Server 2005

No comments yet, be the first one to post comment.

To post your comment please login or signup