BugOfTheDay: How I tuned a procedure to find reservations

from blog Just Some Code, | ↗ original
This time, one of the searching features for reservations was timing out. The appropiate store procedure took ~5 minutes to finish. This is how I tuned it. To tune a store procedure, start by looking for expensive operators in its Actual Execution plan. Reduce the number of joining tables and stay away from common bad practices like putting...