Indexing Archives - Page 8 of 8 - Brent Ozar Unlimited®

Index Fragmentation Findings: Part 1, The Basics

February 6, 2009

We asked the community for index fragmentation information for data mining purposes, and the results are in – and interesting. Over the next couple of weeks, I’ll talk about some of the results we found in the field. What Is SQL Server Fragmentation? SQL Server stores data in pages. To make things easy, think of…

SQL Server Partitioning: Not the Best Practices for Everything

June 12, 2008

Brent Ozar

Partitioning, SQL Server

When SQL 2005 was in beta, I clapped my hands and jumped for joy the first time I played with partitioning. I’ve done a lot of data warehouse work, and partitioning lets the DBA break down massive tables into smaller, easy-to-manage chunks. We can put heavily accessed parts of the table onto fast storage, and…

SQL Server training for developers: primary keys & indexes

April 16, 2006

Brent Ozar

Indexing, SQL Server

I had to do some developer training last week and I wrote up a paper on the basics of primary keys and indexes. Sure, there’s tons of similar stuff around the net, but this is MINE, baby. Our Table: Phone Numbers For our evil training purposes, let’s say we work for the phone company, and…