Performance Tuning
What is SQL Server parameter sniffing and data skew?
How do I fix this? If you found this page you most likely either found yourself in the middle of… [...]
Why is my SQL Server query slower than normal?
Have you ever had a query that runs frequently start to randomly go slower? We all have and without the… [...]
Automatic Tuning: Scalar Functions in SQL Server 2019
With SQL Server 2017 Microsoft improved the journey towards making your code go faster without any code changes required by… [...]
Join us for FryeDay!
Once again it is PASS Summit week in Seattle. This is the biggest event in the world for SQL Server… [...]
Best Hidden Feature in SQL Server 2019
With Microsoft’s Ignite conference this week a lot of new features are being advertised all over the internet. Most likely… [...]
Where did my string or binary data get truncated?
[Updated on 10/25/2018] With MSIgnite being this week tons of great new features are being announced. While many will focus… [...]