• so you want to create a secondary Datafile (.ndf) and create new table(s) to ndf.

    that is easy. But it would a good practise to add a filegroup and then add the ndf to the new filegroup.. this will help in database maintenance tasks, as backup just the primary filegroup etc... but it depends in your scenario: and the most important part is SQL Server will never know to place any new objects on the secondary file, but you can create the object with the ON clause in the new Filegroup... correct me if i am wrong.

    and regarding moving the Table.. you cannot as per my understanding, you can only specify create table with on clause to create it in the new filegroup.

    Alter Database DBNAME

    ADD FILE

    (

    NAME = NewFileName,

    FILENAME = 'PathToFile.ndf',

    SIZE = xxx,

    FILEGROWTH = xxx

    )