Implementing MurmurHash and CRC for SQLCLR 2011-12-07 Programming No Comments .NET, C#, Hashing, Performance, SQL, SQL Server
Thread Synchronisation in SQL Server 2011-11-09 Grade of the Steel SQL Server Archive No Comments Latching, Locking, Multi Core Programming, noSQL, Oracle, Parallelism, Scale, Spinlocks, SQL Server
Exploring Hash Functions in SQL Server 2011-11-06 Grade of the Steel SQL Server Archive No Comments Data Warehouse, Hashing, Keys, Performance, Scale, SQL Server
Boosting INSERT Speed by Generating Scalable Keys 2011-10-05 Grade of the Steel SQL Server Archive No Comments I/O, Keys, OLTP, Performance, Scale, 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
The Ascending Key Problem in Fact Tables– Part one: Pain! 2011-07-01 Grade of the Steel SQL Server Archive No Comments Data Warehouse, Predictability, Query Plans, 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
DL980 Configuration Guidance published 2011-06-10 SQL Server Archive No Comments FusionIO, Hardware, OLTP, Scale, SQL Server
Diagnosing and fixing SOS_OBJECT_STORE spins for Singleton INSERTS 2011-05-30 Grade of the Steel SQL Server Archive No Comments FusionIO, OLTP, Performance, Scale, Spinlocks, SQL Server
Secret Scale Sauce : Heavy Singleton INSERT spinlocks 2011-05-28 Grade of the Steel SQL Server Archive No Comments OLTP, Performance, Scale, Spinlocks, SQL Server