Browsing the blog archives for September, 2010

Move Tables to New Filegroup

About a year ago I showed how to move data in a table to a new partition by modifying the clustered index.  Since the clustered index contains the data for the table, moving the clustered index is equivalent to moving the table. This post is a simpler example of using the clustered index to move […]


SQL Server and Muscle Memory

If you learned to play golf by taking lessons the first time the golf pro sets you up to take your first swing it feels awkward.  After a while, if you listened to your instructor, your swing becomes more natural, you can stop thinking about every aspect of the swing, you can grip it and […]