SQL Server Performance

how can I combine horizontal and vertical partitioning in SQL server

Discussion in 'ALL SQL SERVER QUESTIONS' started by Mariam Nagy, May 20, 2014.

  1. Mariam Nagy New Member

    Hello

    I want to combine horizontal and vertical partitioning because I have a huge table (huge number of records and also a big row size) .. I need to know does this combined partitioning cause any negative performance ..

    Is combining between the two available in SQL server 208 R2?

    Is there any live example for this combining or any video tutorial ?

    Can I perform the vertical partitioning on the primary key ?

    Is there any disadvantages for partitioning?

Share This Page