TPC-H: Schema and IndexesTPC-H: Schema and IndexesTPC-H: Schema and IndexesTPC-H: Schema and IndexesTPC-H: Schema and Indexes 2014-06-30 Data Modeling No Comments Performance, SQL, TPC-H
Running Many Batch Statements in Parallel 2012-01-08 SQL Server Archive No Comments Async, ETL, Parallelism, SQL, SQL Server, Threading
Implementing MurmurHash and CRC for SQLCLR 2011-12-07 Programming No Comments .NET, C#, Hashing, Performance, SQL, SQL Server
The Ascending Key Problem in Fact Tables –Part two: Stat Job! 2011-07-07 Grade of the Steel SQL Server Archive No Comments Data Warehouse, Histogram, Predictability, SQL, SQL Server, Statistics
Latch and Spinlock Papers Published on Microsoft 2011-07-01 SQL Server Archive No Comments Latching, Performance, Scale, Spinlocks, SQL, SQL Server, Tuning
Grade of the Steel: Introduction 2011-05-01 Grade of the Steel SQL Server Archive No Comments Data Warehouse, ETL, FusionIO, OLTP, Performance, Scale, SQL, SQL Server
Utility functions: fn_convert_to_base and fn_nums 2011-04-26 SQL Server Archive Utilities No Comments SQL
Doing FIRST and LAST aggregates in SQL Server 2005 2006-07-10 SQL Server Archive No Comments Aggregations, SQL, SQL Server