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.

 
 
 
 
 
(2)
Add to favorites
Databases
12/30/2012
E-mail Twitter del.icio.us Digg Facebook
Sign in to ask a question


  • 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.