When you purchase through links on our site, we may earn an affiliate commission. Here’s how it works. SQL DBAs (database administrators) are always looking for ways they can optimise their datasets.

As a consultant whose job description includes putting out performance fires, I get to see a lot of problematic queries that can dramatically harm overall server performance and throughput. Wondering ...