Visual Studio Magazine

Mastering SQL Server Indexing: What Every .NET Developer Needs to Know

At the upcoming Visual Studio Live! Las Vegas developer conference, SQL expert Denny Cherry will share essential indexing ...
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 ...
Network World

Paint the town red with non-clustered indexes

So defining it as a sparse column and creating a filtered index will enable SQL Server to optimize access to this column and also save space. Now this actually is a violation of the normalization ...
InfoQ

SQL Server 2016: In-Memory 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 ...