Why Table Partitioning Doesn't Speed Up Query Performance (video)
Learn why SQL Server’s table partitioning feature doesn’t make your queries faster– and may even make them slower.
indexing
Links and Notes from "SQL Server Index Formulas", Huntington Beach
I gave a day long session, “SQL Server Index Formulas, Problems and Solutions” in Huntington Beach, CA on April 1. The class was a great group of students, and we had a lively discussion and lots of questions.
Here’s a topic we diagrammed in class, as well as links to extra resources.