Performance Tuning

Natural Born Killers (The series) – Day 7 Table Variables vs Temp Tables

Natural Born Killers (The series) – Day 7 Table Variables vs Temp Tables

To those that don’t know me “Natural Born Killers (The Series)” sounds like a very strange choice for a SQL Server blog title and to be fair it is. Those who do know me, will know that I have been presenting a session this year titled “Natural Born Killers, performance issues to avoid” around the […]

Improving performance by using SET STATISTICS IO

Improving performance by using SET STATISTICS IO

SET STATISTICS IO ON does pretty much what you would expect, it returns information about IO back to your UI as a message. Why is this important? Well it helps you to understand just how much IO has been performed broken down by object. It actually breaks it down further than that, but we’ll cover that once we’ve seen how it works.

My First White Paper – Top 10 Tips for Optimizing SQL Server Performance

My First White Paper – Top 10 Tips for Optimizing SQL Server Performance

Earlier this year I had the chance to collaborate on my first ever white paper “Top 10 Tips for Optimizing SQL Server Performance” with Patrick O’Keeffe who is Director of Software Development at Dell Software Group. I must say, it was a really interesting experience.

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 […]

T-SQL Tuesday 23 – Key Lookups

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 […]

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 […]