[Database Edition 08] Understand SQL Execution Plans! Essential Knowledge for Finding the Cause of Slow SQL

The theme for this time is SQL "execution plans."Execution plans are one of the technologies you absolutely must understand when considering database performance.However, this content might also be a ...

[Database Series 07] Understand Indexes! Why the Same SQL Can Have Vastly Different Search Speeds

The theme for this session is database "indexes".Indexes are one of the technologies you absolutely must understand when ...
Redmond

Understanding Columnstore Indexes in SQL Server

First introduced in SQL Server 2012, columnstore indexes can give you major performance gains -- provided you have the right workloads. Here's how columnstore indexes work and what types of data work ...
informationweek

Microsoft In-Memory Move Challenges SAP, Oracle

Microsoft made three announcements related to its SQL Server database business Wednesday, but the headliner was clearly "Hekaton," a preview project that promises to bring in-memory OLTP ...