Sunday, 8 July 2018

Trace Flag 7470

Trace flag 7470 works in SQL 2017! I'm always a little reluctant to use trace flags, especially after reading that Trace flags were becoming redundant due to more database level settings.

Anyway, I've eliminated the Sort operator spilling to tempdb by applying 7470.

Note, the documentation says it doesn't apply to SQL 2017, but I had it on good authority that it would,

Trace Flag 7470 : Fix operator spills to tempdb

No comments: