Latest from the COEO blog

Wednesday, October 1, 2014
no comments

In this article I am going to explain that the order of the columns in an index is important. Let’s look at some examples. I am using the Person.Contact table from AdventureWorks. Create a non-clustered composite index as follows. CREATE INDEX NonClust_Contact_Name ON Person.Contact(LastName, FirstName); A composite index is an index made up of more than one column. The… Read more »

Tuesday, September 30, 2014
no comments

The optimizer uses foreign key constrains and check constraints to create more efficient query plan by skipping some part of the query plan because the optimizer can see that there is a foreign key constraint so it is not necessary to execute that part of the plan. Let’s prove this with the help of an… Read more »

Monday, August 4, 2014
no comments

IT vendors increasingly use reviews from analyst firms in their marketing – how should we interpret these? Today, it’s harder than ever to tell how good something is, whether it’s a hotel, suit or software solution. When I look online for reviews all I see is noise. To help find the guidance we need, let’s… Read more »


Find Us

400 Thames Valley Park Drive,
RG6 1PT,
United Kingdom