SQL Server 2019 includes new query processing features such as batch mode on rowstore, memory grant feedback, approximate query processing, and more. How do these work? Are they as good as Microsoft wants us to believe?

This session will cover how to work around hardware issues when it isn’t in the budget for newer, faster, stronger, better hardware. Learn tips and tricks on how to reduce IO,relieve memory pressure, and reduce blocking.