Home Dashboard Directory Help
Search

Allow to create a columnstored or rowstored table by Wim SQL Server


Status: 

Closed


1
0
Sign in
to vote
Type: Suggestion
ID: 767033
Opened: 10/11/2012 5:09:00 AM
Access Restriction: Public
0
Workaround(s)
view

Description

Wouldn't it not be furth to allow a table to be stored in columns rather then in rows directly when creating the table?

Even without compression it would be usefull to store data on column basis in pages.
Some examples of stuff that would be lot's faster:
drop of a column, update of 1 columns for all rows in table (less pages fetched),
altering the size of a column(would only inflict own pages),


Would be really handy for Datawarehouses.

Details
Sign in to post a comment.
Posted by Microsoft on 4/29/2013 at 2:33 PM
Hello,

Thank you for submitting this feedback. After carefully evaluating all of the bugs in our pipeline, we are closing bugs that we will not fix in the current or future versions of SQL Server. The reasons for closing this bug is because the scenario reported in the bug are not common enough and due to the risk of implementing a fix it unfortunately does not meet the bar for the current version of the product.

If you have more supporting information and details or feel strongly that we should reconsider, please do resubmit this item for review.

Thanks again for reporting the product issue and continued support in improving our product.
Gus Apostol, SQL Server Program Manager
Sign in to post a workaround.