Over the last 15+ years as I’ve learnt more and more about SQL Server, I have come to realise how much I love working with it. The more I dig into it, the more I see a need for companies to understand how to keep their data secure, how to keep it available, and how […]
I did some work on sp_BlitzIndex recently. Check out the clip on YouTube:
If you have a complex query, a CTE (Common Table Expression) can be a great way to break down the query into individual parts. What is often overlooked by developers is that CTEs can cause significant performance problems when used incorrectly. A common pattern I have seen is joining to a CTE multiple times. This […]
