New SSMS Features: Click + Drag and Click + Mouse Scroll
Category:
query-performance
The best features are the ones that you use all the time. SQL Server 2016 Management Studio’s bringing improvements in navigating around execution plans.
Tag: execution-plans
Live Query Statistics Do Not Replace Actual Execution Plans
Category:
query-performance
I like SQL Server’s new Live Query Statistics feature a lot for testing and tuning large queries. One of my first questions was whether this could replace using actual execution plans, or if it’s useful to use both during testing.
Finding: Both are useful. And both can impact query performance.
Did My Query Eliminate Table Partitions in SQL Server?
Category:
query-performance
Working with table partitioning can be puzzling. Table partitioning isn’t always a slam dunk for performance: heavy testing is needed. But even getting started with the testing can be a bit tricky!
Here’s a (relatively) simple example that walks you through setting up a partitioned table, running a query, and checking if it was able to get partition elimination.