Partition Function SQL Server?

  • Hi all experts,

    My question is my do we need Partition function?

    What would have happen if microsoft would have not included Partition Function feature in SQL Server?

  • Shadab Shah (6/6/2013)


    My question is my do we need Partition function?

    To tell what rows go in what partition of a partitioned table

    What would have happen if microsoft would have not included Partition Function feature in SQL Server?

    We wouldn't have the partitioned table feature.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Partitioning is required to optimize the performance of SQL Server database. If database contains very large tables, you may benefit from partitioning those tables onto separate filegroups. This technology, introduced in SQL Server 2005, allows to spread data onto different physical disks, leveraging the concurrent performance of those disks to optimize query performance.

    Partitioning a SQL Server database table is a three-step process and Create the partition function is the first step.

  • Partitioning is not primarily for performance.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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