Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Mariam Nagy
Starting Member
3 Posts |
 Posted - 2014-05-20 : 10:45:19
|
| 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? |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-05-20 : 14:03:05
|
| Horizontal "partitioning" could be considered a form of normalization. If this is an OLTP system and there's lots of repeated data (likely, with wide rows), try to normalize your data. Once normalized, you can set up views to return the original, wide rows.Vertical partitioning is done on the clustered index. This can work well if you have the "right" CI -- that is one where newly added records fit on the logical end of the data -- often this is a timestamp or sequence number of some sort. With a good partitioning function, you can achieve your goals. You can even save real money if you can push the oldest/least-frequently-accessed data onto cheaper media (e.g. slower disks). |
 |
|
|
|
|
|
how can I combine horizontal and vertical partiti