Running SQL Server on a Big Box – Configuration 2014-09-23 Grade of the Steel SQL Server Archive No Comments Parallelism, Performance, Scale
Running SQL Server on a Big Box–Scalability 2014-09-15 Grade of the Steel SQL Server Archive No Comments Parallelism, Performance, Scale, SQL Server
Quantifying the Cost of Database Compression 2013-03-11 Databases Grade of the Steel No Comments Compression, Performance, SQL Server
VM-ware Shared folders are really Slow 2012-12-12 Grade of the Steel No Comments Debugging, I/O, Tuning, Virtualization
One Million IOPS on a 2 socket server 2012-09-27 Grade of the Steel SQL Server Archive No Comments FusionIO, Hardware, I/O
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