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

Status : 


Sign in
to vote
ID 767033 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 10/11/2012 5:09:00 AM
Access Restriction Public


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.

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

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