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