Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: Partitioning in SQL Server 2008

    Correct example: Updated existing code

    1)

    USE master

    GO

    CREATE DATABASE MyPartitionPracticeDB

    ON PRIMARY

    ( NAME = db_dat,

    FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\MyPartitionPracticeDB.mdf',

    SIZE = 50MB),

    FILEGROUP FG1

    ( NAME = FG1_1_dat,

    FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\MyPartitionPracticeDBFG1.ndf',

    SIZE = 2MB),

    (...

Viewing post 1 (of 1 total)