Step By Step Table Partition in SQL Server

What is Table Partition ? Partitioning is the database process or method where very large tables and indexes are divided in multiple smaller and manageable parts.

4.5 Star
Add to favorites
E-mail Twitter Digg Facebook
Sign in to ask a question

  • Described graphically by pinal dev
    1 Posts | Last post March 23, 2018
  • No Partition Scheme is created
    2 Posts | Last post June 25, 2015
    • Thanks for your contribution, however you skipped/forgot Step3 and although it's stated in the title of the Step4, there's no a CREATE PARTITION SCHEME script under that item.
    • --Step 3 : Create partition scheme
      CREATE PARTITION SCHEME TestDB_PartitionScheme
      AS PARTITION TestDB_PartitionRange TO ([Primary],TestDB_Part2)
  • Shouldn't be this a blog?
    2 Posts | Last post February 04, 2013
    • Just thinking this is a good topic for a blog, rather a gallery item, 
      However its very informative post, thanks
    • Thanks
  • partition a table using 2 columns
    2 Posts | Last post December 30, 2012
    • Is it possible to partition a table using 2 columns instead of only 1 for the partition function?
    • It is not possible to do using more than a column. But can use the combination of two.
  • Table Partiation
    2 Posts | Last post December 30, 2012
    • What is the difference between Scalar-valued and Table Valued Functions in sql server?
    • Scalar functions, inlining, and performance: An entertaining title for a boring post. In this article, Adam contrasts the performance of a scalar UDF against that of a table-valued UDF for a common purpose – retrieving the MAX OrderQty from AdventureWorks.Sales.SalesOrderDetail for a given ProductID. He goes on to explain that the optimizer doesn’t expand scalar functions nearly as well as it does table valued functions, hence the difference in performance.