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 |
|
kkoolsam
Starting Member
4 Posts |
 Posted - 2008-07-02 : 12:16:40
|
| Can any body help?. Ca we implement Partition view at column level in SQL server?..We have one table with 24 columns, out of which 10-15 columns are used rest are not used, can we build partition view on same?...SAM |
|
|
atulmar
Starting Member
7 Posts |
Posted - 2008-07-03 : 14:14:59
|
| You need to do vertical partitioning, that means you need to move some of your columns into different table.As I understand partition view concept is for horizontal partitioning, where you have lot of data (millions) in table or implementing some archiving feature.ThanksAtul |
 |
|
|
atulmar
Starting Member
7 Posts |
Posted - 2008-07-03 : 14:16:35
|
| Just to add one more thing here, you need to have primary key of the table in both the columns to reference the records from second table.ThanksAtul |
|
|
|
|
|
|
Information about Partition Views