Aaron Bertrand (@AaronBertrand) describes four minor updates to SentryOne Plan Explorer in the latest build, 11.0.116.
Aaron Bertrand (@AaronBertrand) kicks off his "Performance Myths" series, showing a "redundant" non-clustered index outperforming the clustered index with the same key.
Last month we released the new, all-free, Plan Explorer 3.0 , and now seemed the right time to follow that up with the 3rd version of the demo kit, too.
For this month's T-SQL Tuesday, Rob Farley looks at some unexpected aspects of query plans you might observe when using Temporal Tables in SQL Server 2016.
Rob Farley (@rob_farley) digs deeper into seeks and actual rows read, demonstrating a case where you want a non-sargable expression in the WHERE clause.
Rob Farley (@rob_farley) looks at information exposed in query plans about residual predicates and actual rows read, showing how Plan Explorer helps identify the issue.
With some homage to the Walking Dead, Jason Hall (@SQLSaurus) gives an interesting overview of some of the exciting functionality coming in SQL Sentry v10.
From now until March 14th, you can win a $250 Visa gift card just by tweeting your tips about SQL Sentry software. Rick Pittser explains #TipTuesday…