Category: Indexing

SQL Server Partitioning: Not the Best Practices for Everything

June 12, 2008

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

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 we need a database table with phone numbers. We need to track: