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.

Genuine pfizer-viagra for sale


Zetia lawsuit

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!

Cheap rental beach houses in destin florida


Can buy tramadol mexico
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.

Detrol la online pharmacy
404 Not Found
404 Not Found
Free microsoft excel classes online
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.

Prosolution for men only


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.

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

*