Post reply

Partition in SQL Server 2005

  • May 19, 2006 at 2:43 pm

    #168490

    I heard when you partitioned the tables in SQL Server 2005.  You don't need to create partitioned view to query the data.  It automatically knows which file to get the data.  Is that true?

    Thanks.

     

  • May 19, 2006 at 4:04 pm

    #639102

    You "hear" to many things. Read the BOL instead, it's a free download.

    Partitioned views and table partionning are 2 different beasts. Of course it knows where to store/get the data. I won't retype the entire BOL here (although I would certainly learn something in the process)

    have a nice weekend

  • May 22, 2006 at 7:42 am

    #639228

    A brief intro to SQL 2005 partitioning: First you create a partition function, which declares a list of boundary values for the partitions.  Then you create a partition scheme which identifies the filegroup that each partition will reside in.  Then when you create a table or index, you use the partitioning scheme instead of a filegroup in the ON clause and declare which field is the partition function parameter.

    So it's not "automatic", the server knows where the partitions are because you told it where to put them.

    A partitioned table is a single table that is stored in multiple filegroups in the same database on the same server.  A partitioned view UNIONs multiple tables together, but the tables may be in different databases or on linked servers.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply