Performance Tuning

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