Writing queries without data

Sometimes it’s not possible to have the data you need in order to create the most efficient queries possible. This may be because you don’t have a machine with enough storage capacity, it might even be on a laptop so there is also the security aspect. So how do you address the issue of writing queries [...]

T-SQL Tuesday 23 – Key Lookups

This post is brought to you by the letter “K”. Those of you that have been following my blog and tweets recently will know all about the SQLRelay event that is happening in the UK this week. Tonight is the second of a four night series of events culminating on the 6th October in London where [...]

SQL Workshops

If you have been to any of the SQLBits events many of you will have no doubt made a conscious effort to go to the sessions by Ramesh Meyyappan. Ramesh is absolutely awesome at performance tuning, you can see some of his previous presentations at the SQLBits site here, but did you know that he has [...]