New Pluralsight course: Indexing for Performance

Posted on: September 18, 2017 11:26 am

On index key size, index depth, and performance

Posted on: October 23, 2015 1:29 pm

Low priority locking wait types

Posted on: October 16, 2015 2:48 am

New course: Index Fragmentation Internals, Analysis, and Solutions

Posted on: June 5, 2015 9:11 am

How would indexes on AG readable secondaries work?

Posted on: May 14, 2015 6:52 am

Are mixed pages removed by an index rebuild?

Posted on: June 10, 2014 10:15 am

Online index rebuild corruption bug in SQL Server 2012 SP1

Posted on: June 10, 2014 8:56 am

DBCC CHECKDB performance and computed-column indexes

Posted on: March 25, 2013 1:46 pm

Tracking page splits using the transaction log

Posted on: February 7, 2013 11:43 am

How are per-column modification counts tracked?

Posted on: March 13, 2012 11:30 am

Code to list potential cluster key space savings per table

Posted on: February 6, 2012 1:20 pm

How cluster key size can lead to GBs of wasted space

Posted on: January 2, 2012 6:46 am

Survey: wasted space from cluster keys (code to run)

Posted on: November 8, 2011 2:49 pm

Code to list index counts per table

Posted on: November 2, 2011 11:20 am

Over and under indexing – how bad is it out there?

Posted on: November 1, 2011 1:15 pm

TechNet Magazine: September 2011 SQL Q&A column

Posted on: September 14, 2011 5:43 am

Survey: nonclustered index counts (code to run)

Posted on: August 4, 2011 3:27 pm

Beware of advice from 3rd-party tools around dropping indexes

Posted on: April 4, 2011 1:12 pm

Do changes to index keys really do in-place updates?

Posted on: February 25, 2011 9:22 am

Missing index DMVs bug that could cost your sanity…

Posted on: May 1, 2010 4:41 pm

A SQL Server DBA myth a day: (29/30) fixing heap fragmentation

Posted on: April 29, 2010 8:22 am

A SQL Server DBA myth a day: (25/30) fill factor

Posted on: April 25, 2010 9:51 am

A SQL Server DBA myth a day: (8/30) unicorns, rainbows, and online index operations

Posted on: April 8, 2010 7:24 am

Inside sys.dm_db_index_physical_stats

Posted on: March 9, 2010 10:18 am

Where do the Books Online index fragmentation thresholds come from?

Posted on: December 8, 2009 1:23 pm

TechNet Magazine: August 2009 SQL Q&A column

Posted on: July 17, 2009 1:57 pm

An example of a nasty cluster key

Posted on: May 20, 2009 12:45 pm

Clustered or nonclustered index on a random GUID?

Posted on: May 14, 2009 9:34 am

How expensive are page splits in terms of transaction log?

Posted on: May 12, 2009 5:50 pm

Index rebuilds depend on stats, which are updated by index rebuilds?!?

Posted on: March 27, 2009 7:28 am

Importance of index maintenance

Posted on: March 21, 2009 3:50 pm

Weekly survey: index maintenance plan

Posted on: March 13, 2009 6:06 pm

TechNet Magazine: April 2009 SQL Q&A column

Posted on: March 11, 2009 12:57 pm

TechEd demo: nonclustered index corruption

Posted on: December 17, 2008 11:03 am

Corruption bug that people are hitting – Msg 2511 using DBCC DBREINDEX

Posted on: November 14, 2008 5:53 pm

Conference Questions Pot-Pourri #8: How to move constraint indexes?

Posted on: November 10, 2008 10:38 am

RunAs Radio interview on indexes (and future projects…)

Posted on: September 30, 2008 10:28 pm

Dev Connections newsletter

Posted on: September 10, 2008 7:29 am

Search Engine Q&A #26: Myths around causing corruption

Posted on: August 27, 2008 5:11 pm

Can GUID cluster keys cause non-clustered index fragmentation?

Posted on: August 20, 2008 7:11 pm

User groups and classes in August and September

Posted on: August 11, 2008 6:36 pm

We’re writing a book – finally!

Posted on: July 10, 2008 10:37 pm

Search Engine Q&A #19: Misconceptions around index rebuilds (allocation, BULK_LOGGED mode, locking)

Posted on: June 8, 2008 5:12 pm

How hard is it to pick the right non-clustered indexes?

Posted on: May 14, 2008 10:13 pm

Search Engine Q&A #10: Rebuilding Indexes and Updating Statistics

Posted on: January 27, 2008 12:01 am

SQL Server 2008: Spatial indexes

Posted on: January 17, 2008 7:59 pm

Paul and Kimberly interview on RunAs Radio – What’s New in SQL Server 2008?

Posted on: December 12, 2007 6:07 pm

Auto-shrink – turn it OFF!

Posted on: November 13, 2007 4:28 am

Conference Questions Pot-Pourri #3: unexpected index rebuild results and bulk-logged operations

Posted on: November 6, 2007 11:17 pm

Indexes From Every Angle: What indexes are necessary when using SWITCH PARTITION?

Posted on: November 1, 2007 2:05 am

Indexes From Every Angle: How can you tell if an index is being used?

Posted on: October 5, 2007 1:39 am

Indexes From Every Angle: What happens to non-clustered indexes when the table structure is changed?

Posted on: October 5, 2007 12:52 am