Predicate Logic, Four Things I Wish I’d Known Sooner, Transact-SQL Bad Habits, Rewriting Queries to Improve Performance

Some of my favorite 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.

Speak Your Mind

*

This site uses Akismet to reduce spam. Learn how your comment data is processed.