Latest from the COEO blog

Tuesday, February 24, 2015
no comments

  In this post I want to provide a brief overview of horizontally partitioned views. One of the reasons for covering partitioned views is that it provides a mechanism for “sharding” data in such a way as to provide significant performance benefits, which I’ll explore in a future post.   Scaling Up The basic idea… Read more »

Monday, January 5, 2015
no comments

It is the time of year for new year resolutions, so I’m asking you, dear reader, to make one this year and if you take the challenge I will pledge my support. I have visited many organisations during 2014 who are running production work loads on SQL Server 2005 and Windows Server 2003. While on… Read more »

Wednesday, December 24, 2014
no comments

In-memory ColumnStore Indexes in SQL Server 2014 can be a performance game changer for workloads involving large datasets.  They can also significantly affect the amount of server resource needed to provide good query performance – but not always in the ways you’d expect. A familiar database server performance issue It’s common to see a transactional… Read more »


Find Us

710 Wharfedale Road,
Winnersh, Wokingham,
Berkshire, RG41 5TP,
United Kingdom