Posts by Brent Ozar

Getting GroupBy.org Ready for GDPR Compliance

1 Comment
By now, you’ve probably heard of the EU’s General Data Protection Regulation (GDPR). It’s a hugely far-reaching set of regulations, but here’s a very abridged background: If your business holds data for EU citizens or residents – regardless of where your business is located – you’re affected When EU folks are handing over their data,…
Read More

What to Do When SQL Server is Unusually Slow

11 Comments
Target Audience: You use Activity Monitor to figure out what’s going on, and you feel like you might be missing something. Abstract: “Is something going on with the SQL Server right now?” You hear those words, and your heart starts to race a little faster. You try to connect to the SQL Server, and it…
Read More

Getting Better Query Plans by Improving SQL’s Estimates

15 Comments
Target Audience: You want faster queries, and you’re starting to read execution plans to figure out what to do. Abstract: You’ve been writing T-SQL queries for a few years now, and when you have performance issues, you’ve been updating stats and using OPTION (RECOMPILE). It’s served you well, but every now and then, you hit…
Read More
Menu