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

A digest of great articles originally appearing at SQLPerformance.com.

Cardura xl tablets


What is the medication azathioprine used for
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!

Aldactone blood test


Is nexium better than prilosec
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.

Buy naltrexone from mexico
404 Not Found
404 Not Found
What color are aricept tablets
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.

Panadol extra recommended dose


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: http://www.sqlsentry.com/company/more-news

Share and Enjoy:
  • Print
  • Digg
  • StumbleUpon
  • del.icio.us
  • Facebook
  • Yahoo! Buzz
  • Twitter
  • Google Bookmarks
  • email
  • LinkedIn
  • Ping.fm
  • HackerNews
  • Posterous
  • Reddit
  • Technorati
  • Tumblr

Speak Your Mind

*