Updatable columnstore index, sp_spaceused and sys.partitions

Posted by Michael Zilberstein on SQL Blog See other posts from SQL Blog or by Michael Zilberstein
Published on Mon, 01 Jul 2013 16:15:15 GMT Indexed on 2013/07/01 16:26 UTC
Read the original article Hit count: 240

Filed under:

ColumnstoreIndex

|

internals

|

SQL2014

Columnstore index in SQL Server 2014 contains 2 new important features: it can be clustered and it is updateable. So I decided to play with both. As a “control group” I’ve taken my old columnstore index demo from one of the ISUG (Israeli SQL Server Usergroup) sessions. The script itself isn’t important – it creates partition function with 7 partitions (actually 8 but one remains empty), table on it and populates the table with 63 million rows – 9 million in each partition. So I used the same script...(read more)

Related posts about internals

SQLAuthority Book Review – Professional SQL Server 2008 Internals and Troubleshooting

as seen on SQL Authority - Search for 'SQL Authority'
Professional SQL Server 2008 Internals and Troubleshooting by Christian Bolton, Justin Langford, Brent Ozar, James Rowland-Jones, Steven Wort Link to Amazon (Worldwide) Link to Flipkart (India) Brief Review: Having a book on internal and associating that with real life is “almost” an impossible task… >>> More
New Webcast - SQL Server Internals & Architecture

as seen on SQL Blog - Search for 'SQL Blog'
Join me tomorrow for the PASS DBA Virtual Chapter meeting SQL Server Internals & Architecture (or view the archive). It's the most fun you'll ever have learning about the inner workings of a relational database - I promise!...(read more) >>> More
SQLAuthority Book Review Professional SQL Server 2008 Internals and Troubleshooting

as seen on Dot net Slackers - Search for 'Dot net Slackers'
Professional SQL Server 2008 Internals and Troubleshooting by Christian Bolton, Justin Langford, Brent Ozar, James Rowland-Jones, Steven WortLink to Amazon (Worldwide)Link to Flipkart (India)Brief Review: Having a book on internal and associating that with real life is almost an impossible task. The… >>> More
Bob Dorr’s SQL I/O Presentation on PSS Blog

as seen on SQL Blog - Search for 'SQL Blog'
In case you missed it, Bob Dorr from the PSS Team posted an amazing blog post today yesterday with all of the slides and speaker notes from his SQL Server I/O presentation. This is a must read for and Database Professional using SQL Server. http://blogs.msdn.com/psssql/archive/2010/03/24/how-it-works-bob-dorr-s-sql-server-i-o-presentation… >>> More
Bob Dorr’s SQL I/O Presentation on PSS Blog

as seen on SQL Blog - Search for 'SQL Blog'
In case you missed it, Bob Dorr from the PSS Team posted an amazing blog post today yesterday with all of the slides and speaker notes from his SQL Server I/O presentation. This is a must read for and Database Professional using SQL Server. http://blogs.msdn.com/psssql/archive/2010/03/24/how-it-works-bob-dorr-s-sql-server-i-o-presentation… >>> More

Developer IT