Why “Date BETWEEN FromDate AND ToDate” is a dangerous join criteria 2012-06-29 Data Modeling No Comments Data Warehouse, Dimensional Models, Histogram, Historizing, OLTP, Query Plans, Statistics
Table Pattern: Database Message QueuesTable Pattern: Database Message QueuesTable Pattern: Database Message QueuesTable Pattern: Database Message QueuesTable Pattern: Database Message Queues 2012-05-25 Databases No Comments Latching, OLTP, Patterns, Performance, Relational
Don’t Become a One trick Architect 2011-12-08 Data Modeling No Comments Architecture, Cursors, Data Warehouse, ETL, HADOOP, Hardware, OLTP, XML
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
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
Good keys, what are they like? 2011-05-13 Data Modeling No Comments Data Warehouse, Keys, OLTP, Relational
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