Why Your SQL Server View Is Slow (And How an Inline TVF Fixes It)
Arnaud Pouppeville
The query had been running fine for months. It pulled ad performance summaries by dealer: counts, impressions, nothing exotic. Then one morning it stopped finishing. Timeout after timeout, and nobody had changed the code.What had changed was the data. AdEvents had grown from a few hundred thousand...