question

smayer avatar image
smayer asked

SQL Server 2012 Vertical Partition -- User Sees 1 Table?

Can SQL Server vertically partition a table internally (like horizonal partitioning, user sees ONE table ... and not a view)?
partition
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Kev Riley avatar image
Kev Riley answered
No. But why not a view?
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

smayer avatar image smayer commented ·
Thanks for your response. I am not using a view because it would require application changes (e.g., updates that might affect both tables) and extra maintenance (e.g., indexing both tables). Horizontal partitioning is great because the application can do everything it has always done, as can my maintenance and other routines, with no knowledge of multiple tables behind the scenes.
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.