Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

RealSQLGuy - Helping You To Become A SQL Hero

My real name is Tracy McKibben. I’ve been working with database products for over 20 years, starting with FoxBase running on Xenix. Over the years, I’ve worked with all flavors of FoxPro, some Clipper and dBase, and starting somewhere around 1995, SQL Server. I’ve even dabbled with Oracle, though I’ve tried to block out all memories of that experience. At present, I’m the Senior SQL Server DBA and the DBA Team Supervisor for Pearson VUE. All opinions expressed on this site are my own and do not reflect the opinions of Pearson VUE.

Friday Followup For December 20, 2013

lazy_superman

It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re not doing any real work anyway.

Posts That Were Popular This Week

Comments That Were Posted This Week

  • Andy on Using A Non-correlated Subquery To Avoid DISTINCT:
    Great article! I cringe whenever I see “SELECT DISTINCT…”. To me it’s a red flag that somebody probably stuck a band-aid on their query because they didn’t understand why it was returning duplicates.

    In your experience, does it make any performance difference if you use WHERE EXISTS versus WHERE IN, or do both techniques generate the same query plan? (I’d check myself, but something must be terribly wrong with me because I don’t have the AdventureWorks2012 database running anywhere!)

  • realsqlguy on Using A Non-correlated Subquery To Avoid DISTINCT:
    Thanks Andy. As far as I know, in almost every case, WHERE IN and WHERE EXISTS are processed in the same way by the query optimizer. The only difference is in how you construct the query.
  • Robert L Davis on Don’t Bring a Tank to a Prison Fight – #TSQL2SDAY #49:
    Thanks for your entry in T-SQL Tuesday #49.
  • Paul Timmerman on I’m Board:
    Congrats Tracy! I know you’ll do a great job. (wait, was I just nice to you??)
  • realsqlguy on I’m Board:
    I’m as shocked as you are…

This Week In History

None, the past holds no lessons this week

That’s it for this week. Get back to work!

batman_retired

Comments

Leave a comment on the original post [realsqlguy.com, opens in a new window]

Loading comments...