Since the columnstore index was first introduced back with SQL Server® 2012, there have been a lot of questions about when you should use a columnstore and when you should use a traditional rowstore index. This is especially true following Microsoft’s latest enhancements to the columnstore. Microsoft touts some impressive performance gains using the columnstore […]
Read More
Don’t believe everything you read on the web about clustered vs. nonclustered indexes I suspect almost every reader of this article has seen or heard the following, as it is posted “everywhere” on the web. Yet if the advice is taken blindly, it can rob your system of top performance. Every table should have a […]
Read More
SQL Server table partitioning is generally suggested on a natural key. Learn how to implement it when there are child tables.
Read More
Learn about query performance and some SQL Server benchmarking comparisons of the primary key and the clustered index.
Read More
Some SQL Server experts advocate letting an identity column define the primary key for large tables. Here we examine the pros and cons as well as the syntax for breaking apart the primary key and the clustered index.
Read More