Latest Entries
SQL Server DBA / sqlLAB

SQL Query Tuning: Non-SARGable Conditions & Optimising Joins

Recently I got the chance to do some query tuning for a client. The client had contacted us because their users were experiencing particularly slow performance running reports from their BI Dashboard. Their internal teams thoroughly reviewed their network and SSRS packages and couldn’t find anything untoward. When they dug deeper into one particularly slow … Continue reading