Predicate Pushdown and why should I care?

Cross post with http://aka.ms/sqlserverteam If you follow this blog, you know that in the last couple years, we have been adding more information to showplan, to make it a one-stop-shop for all your query performance troubleshooting insights. You can see more about those showplan enhancements here. Hold on, there’s a reason I’m writing about showplan:…


More Showplan enhancements – UDFs

Cross post with http://aka.ms/sqlserverteam As I mentioned on yesterday’s post, with the recent release of SQL Server 2017 CU3, we released yet more showplan enhancements: you can see other posts related to showplan enhancements here. In this article I’ll talk about the second showplan improvement we worked on, to assist in the discoverability of UDF…

0

More Showplan enhancements – Row Goal

Cross post with http://aka.ms/sqlserverteam As I shared before, we have been working for over a year to make showplan the one-stop-shop for query performance analysis and troubleshooting (as much as possible). With the recent release of SQL Server 2017 CU3, we released yet more showplan enhancements: you can see other posts related to showplan enhancements…

0