Column order can matter

Ordinarily, column order of a SQL statement does not matter.
Select a,b,c
from table
will produce the same execution plan as Select c,b,a
from...

Kent .Net/SqlServer User Group – Upcoming events

At the Kent user group we have two upcoming events.  Both are to be held at F-Keys Training suite http://f-keys.co.uk/...

SqlHerts–26th May 2011

Thanks to those who turned out to see my presentation at SqlHerts on Thursday 26thMay.  Its a true pleasure to...

#SqlBits and SSIS custom components

If you are in anyway interested in SQL Server and live in the UK,  you cant of failed to of...

Do you know SqlServer ? Do you want an iPad ?

If you’ve answered yes to both of those questions , Jacob Sebastian has some more question for you.
Every day in March...

“Apparently, you signed a software services agreement without fully understanding it.”

I am not a lawyer. Let me say that again, I am not a lawyer.

Todays Dilbert has prompted me...

Denali Paging–Key seek lookups

In my previous post “Denali Paging – is it win.win ?” I demonstrated the use of using the Paging functionality within Denali. ...

Denali Paging–Is it win/win ?

I'm not one for automatically poo-pooing new ideas, new practices and new technology.  Rather I like to take a measured...

The best things in life are free

Greg Gonzalez (blog | twitter) of SqlSentry, last night released a very cool new and free product.  Plan explorer is a...

An impossible case

In a previous blog entry (Inconsistent NullIf behaviour), Jeff Moden and Dan Halliday(twitter) both made a very similar observation.
When executing...