Archives: June 2011
In my last blog I showed how persisted data may not be used if you have used the base data on an include on an index.
That wasn't the only problem ive had that showed the same symptom. Using the same code as before, I was executing similar to the… Read more
Not that you would know it from the page below, but Itzik Ben-Gan is back in London to do a 5 day training course, start 03october.
Why QA are not screaming this from the rafters, I will never be able to fathom. Its kind of like going for a physics… Read more
Working at a client site, that in itself is good to say, I ran into a set of circumstances that made me ponder, and appreciate, the optimizer engine a bit more.
Working on optimizing a stored procedure, I found a piece of code similar to :
Ordinarily, column order of a SQL statement does not matter.
However, sometimes it can make a difference.
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/ in Rochester, Kent.
If you haven’t attended before please note the location here.
Is your code S.O.L.I.D ?
Everybody keeps on about SOLID principles but what… Read more