Monthly Archives: January 2015

Entity Attribute Value (EAV) data model meets SQL Server Clustered Columnstore for dramatic performance improvement (Part #1) 2

<sarcasm>Want to have complete flexibility adding/removing attributes without DDL, store all your data in a single database table and still have performance then read on….</> It’s often the complaint¬†of¬†developers they can’t easily adjust the data model and add more attributes to it (columns), rightly or wrongly it happens and it’s a legitimate requirement. Ordinarily data […]

SQL Server Version Upgrade – Don’t follow the myth of migrating to the previous version! 3

I thought I’d put out some thoughts around why I think people who’d rather migrate to or start a project afresh with SQL Server [Previous] are potentially costing themselves a lot of pain, resource and thus cash in the longer term. I’ve been working with SQL Server and Windows since the very early days – […]

%d bloggers like this: