Change Data Capture records changes without triggers or schema changes. Here are my notes on tuning the performance of Change Data Capture in SQL Server 2008.
SQL SERVER – Outer Join in Indexed View – Question to Readers
Why can’t you use an outer join in indexed view definitions? The SQL Server 2008 white paper answer, plus my question to you: can you show an example?
SQL SERVER – Interesting Observation – Index on Index View Used in Similar Query
A query on the base table used an index it did not own. It was the index on index view of the same table, an interesting observation from an optimization project.
SQL SERVER – Plan Caching and Schema Change – An Interesting Observation
What counts as a schema change for plan caching? More than table structure: adding or dropping an index also qualifies, per Greg Low’s white paper.
SQL SERVER – Introduction to Spatial Coordinate Systems: Flat Maps for a Round Planet
An easy and humorous Microsoft white paper by Isaac Kunen on spatial coordinate systems in SQL Server, starting with Columbus and a round Earth.
SQL SERVER – Designing SQL Server 2005 Analysis Services Cubes for Excel 2007 PivotTables
A Microsoft white paper on designing Analysis Services cubes that work well with Excel 2007 PivotTables, shared after requests from my BI roadshow.
SQL SERVER – Plan Caching in SQL Server 2008
Plan Caching in SQL Server 2008, a white paper by Greg Low on how plans are cached, when batches recompile, and how to get more reuse from cached plans.