SQL Server Performance  Vertical Partitioning  Discussion in
'General Developer Questions' started by amitm79, Jan 10, 2005.
1. amitm79 New Member      Hi All,     Can anybody tell me a
practical scenario wherein you have used vertical partitioning
to solve an issue and it has improved performance? I want to
prototype Horizontal/Vertical/Hybrid/No partitioning based on my
data and see if it improves performance. Horizontal partitioning
is giving me significant improvement. Now i want to implement
vertical partitioning to check the results. I am not able to
relate the concept to its practical use as keeping all records
in the same table takes me back to the issue of un-partitioned
data theoretically. Any help/link on it is welcome.    2. satya
Moderator      What is the size of database you want to consider
this vertical partitioning?      It's important when you break
your data apart in a vertical partitioning scheme to retain the
relational integrity of your database. Depending upon your
database's constr