THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Documentation » Tricks   (RSS)
  • Exists Vs. Count(*) - The battle never ends...

        I am still amazed at how many of the database applications written today still disregard some basic rules of thumb when it comes to accessing the data. One in particular is the use of COUNT(*) to check to see if there are any rows that match some criteria. The technique of using EXISTS over COUNT(*) has been widely publicized ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on December 15, 2007
Privacy Statement