I have a small doubt.
I have a database called NORTHWIND in my Sql Server 2008. In the database i have table called Categories (which is a part of the primary file group). I want to move this table to a secondary file as i don't use this table often.
In what way can I achieve this requirement?