Race Condition when Creating Unique Values 2014-03-19 SQL Server Archive 6 Comments Locking, MySQL, SQL Server
Clustered Index vs. Heap 2014-01-12 SQL Server Archive 41 Comments Keys, Patterns, Performance, Scale, SQL Server
Myth Busting Query Optimisation 2013-07-01 Data Modeling Databases 8 Comments Performance, Query Plans, SQL Server
Quantifying the Cost of Database Compression 2013-03-11 Databases Grade of the Steel 17 Comments Compression, Performance, SQL Server
Configuring Kernel Debugging with WinDbg and a NULL modem 2012-12-05 Utilities 8 Comments Debugging, Performance, SQL Server, Tuning
Why You Need to Stop Worrying about UPDATE Statements 2012-04-27 Data Modeling 5 Comments Data Warehouse, FusionIO, Keys, Patterns, Performance, Relational, SQL Server
When Database Statistics are not Enough – Search Patterns 2012-02-21 Data Modeling Databases 4 Comments Histogram, I/O, Patterns, SQL Server, Statistics
Running Many Batch Statements in Parallel 2012-01-08 SQL Server Archive 7 Comments Async, ETL, Parallelism, SQL, SQL Server, Threading