InfoQ

SQL Server 2016: Clustered Columnstore Index Enhancements

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Jinsong Yu shares deep architectural insights ...
InfoQ

SQL Server 2016: Updatable, Non-Clustered Columnstore Indexes

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Vivek Yadav, an engineering manager from ...
Ars Technica

SQL Server: reindexing clustered indexes and killnig a reindex job

We updated an app recently which imposed a lot more clustered indexes then had previously been there. We also have a weekly index rebuild which I'm assuming is now running super long because of those ...
CIOL

Filtered Indexes in SQL Server 2009

BANGALORE, INDIA: SQL Server 2008 comes with quite a few new features that have more stress on query performance such as filtered index. In this article, we will see how exactly filter indexes help ...