Data Tales #10: A Matter of Existence

Hi Folks,

I’ve been continuing with my Data Tales series up at sqlmag.com.

This time I’ve written about a pet hate: seeing code that counts rows when all it needs to do is to check for existence. However, all is not as bad as it seems because the optimizer does a pretty good job of protecting us from ourselves. (At least the SQL Server optimizer does Smile)

It’s here: http://sqlmag.com/sql-server/data-tales-10-it-s-matter-existence

Enjoy !

One thought on “Data Tales #10: A Matter of Existence”

  1. very useful information provided in this blog. concepts were explained in a detailed manner. Keep giving these types of information.

Leave a Reply

Your email address will not be published.