how can I combine horizontal and vertical partitioning in SQL server
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?
Is this possible? Yes. But partitioning within SQL Server is primarily a tool for data management and only on a lesser and secondary aspect does it help performance. Here is an [introduction to partitioning] in SQL Server. I don't know of a video tutorial on the topic. Try searching the internet. Are there disadvantages to partitioning? Yes. Management is much more difficult. You must have much more discipline in how you write your queries. Performance may suffer, especially if you don't write the queries correctly. It's a huge topic. :