SQL Server Query Optimization

Get a high-level overview of the secret inner workings of the SQL Server 2012 Query Optimizer.

Read More

Improving SQL Server Query Performance with Indexes

Learn how to use SQL Server 2012 Dynamic Management Views (DMVs) to fine-tune SQL queries.

Read More

SQL Server Fragmentation

Learn how SQL Server fragmentation can affect the performance of a query due to the order of pages and extents in a table.

Read More

SQL Server Primary Key vs Clustered Index, Part 3: Table Partitioning and Partition Key Selection

SQL Server table partitioning is generally suggested on a natural key. Learn how to implement it when there are child tables.

Read More

SQL Server Primary Key vs. Clustered Index: Query Performance and Benchmarking Analysis

Learn about query performance and some SQL Server benchmarking comparisons of the primary key and the clustered index.

Read More