ICYMI - Predicate Logic, Four Things I Wish I'd Known Sooner, Transact-SQL Bad Habits, Rewriting Queries to Improve Performance
A digest of great performance tuning articles originally appearing at SQLPerformance.com.
Why Not Seek Predicate
Paul White ( b | t ) proves, once again, why he is the best in the business when it comes to debugging a SQL Server query. In this post, Paul gives you a step-by-step breakdown of a query that goes astray due to implied predicate logic. Got a tough query of your own? Post it atanswers.sqlperformance.com!
Four Things I Wish I Knew Sooner as a SQL Server DBA
Lori Edwards ( b | t ) tells four things she wished she knew before she started her many year career as a SQL Server database administrator. Hint – the best DBAs don’t excel based solely on technical prowess.
Transact-SQL Bad Habits Revival
Our own Aaron Bertrand ( b | t ) has been blogging and speaking about T-SQL Bad Habits for years. This outstanding blog post recaps his many entries and examples on the topic and points out all of the places where you can read more.
Rewriting Queries to Improve Performance
Another article from Paul White, looking at several situations where alternative T-SQL examples should produce comparable execution plans, but do not. In fact, these queries actually benefit most from a full rewrite.
Read more SQL Sentry happenings in our monthly eNews at: https://sentryone.com/community
Kevin (@kekline) serves as Principal Program Manager at SentryOne. He is a founder and former president of PASS and the author of popular IT books like SQL in a Nutshell. Kevin is a renowned database expert, software industry veteran, Microsoft SQL Server MVP, and long-time blogger at SentryOne. As a noted leader in the SQL Server community, Kevin blogs about Microsoft Data Platform features and best practices, SQL Server trends, and professional development for data professionals.