home

Presented at SQL Rally Copenhagen Oct 2012

Automating Performance Data Collection, Analysis etc.

Presented at SQL PASS Deutschland

SQL PASS Deutschland

SQL Server Query Optimizer Cost Formulas

SQL Bits Presentations, 2010

These are the slidedecks that I used for my SQL Bits presentation on Scaling Data Warehouse on Big Iron Systems. The slidedecks could probably support 4 hours, and the session was only 1 hour, so I will try to write it up as an article. Some of this is already done. See the Parallelism section in Cost Based Optimizer the NUMA chapter in System Architecture, and the Storage section.

System Architecture

Storage

Parallel Execution

TPC-H SF10 Studies

TPC-H Published Results

SQL Server 2008 Presentations

Automating Performance Data Collection, Analysis etc.

Performance for Small/Medium Business

SQL Server Query Optimizer Cost Formulas

Storage Configuration, NOVA 2009

SQL Server 2005 Presentations

SQL Server 2005 Performance Enhancements for Large Queries

SQL Server 2000 Presentations from past conferences

Execution Plan Cost Formulas

Quantitative Performance Analysis, CMG2004

Loop Merge and Hash Joins

Insert Update Delete

Large Data Operations

Parallel Execution Plans

Storage Performance, Connections Spring 2005 ?