SQL Server 2014 New Features: How to Create and Test a Clustered Columnstore Index

How to Create a Clustered Columnstore Index In my last post we looked at what are clustered columnstore indexes, their benefits and how they have changed in SQL Server 2014. Now, let’s learn how to create one.  Since we would like to make some performance measurements on a clustered columnstore index, we will use a sample […]
Read More ›

SQL Server 2014 New Features: Clustered Columnstore Index Features

Clustered Columnstore Indexes – Enforcing Uniqueness and Creating Nonclustered Indexes We have seen that once a table has been physically implemented as a clustered columnstore index, further indexes are not supported. We shall now take a look at how to circumvent this limitation, albeit at the cost, perhaps substantial, of additional hard drive space. While […]
Read More ›

SQL Server 2014 New Features: Cardinality Estimation in the Query Optimizer

Is it Better or Worse? What is Cardinality Estimation A fancy-sounding phrase, “cardinality estimation” basically means “guessing how many”. The ability of the query optimizer to select a superior query plan from among many possibilities requires the estimation of how many rows will be extracted from the participating tables and how these rows will be […]
Read More ›

SQL Server 2014 New Features: Fundamentals of Clustered Columnstore Indexes

SQL Server Columnstore Indexes Columnstore indexes were introduced into SQL Server in 2012, but in a sense the columnstore index is older than that, since the fundamental structure was first used for the tabular storage model of Power Pivot (and then used in the Analysis Services tabular model). In SQL Server 2012, however, columnstore indexes were […]
Read More ›

SQL Server 2014 New Features: Encrypted Backup

James X. from Learning Tree’s Course 535 Developing High Performance SQL Server Databases asked a question (during coffee break) that wasn’t related to performance, but was important nonetheless. “Is it true that someone can circumvent a lot of SQL Server’s security by simply restoring a database backup to a different machine where he or she […]
Read More ›

Type to search blog.learningtree.com

Do you mean "" ?

Sorry, no results were found for your query.

Please check your spelling and try your search again.