THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » developer » Documentation   (RSS)
  • Stopping Execution of Future Batches

      There is a command that as far as I can tell has been in the product since SQL2008 but I was woefully unaware of. Actually I find many others are unaware as well and hence the blog post. The command is SET NOEXEC which has options for ON or OFF.  Normally this is OFF by default and the issue I was trying to solve was this: I have a ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on February 17, 2017
  • SQL Server 2008 R2 System Views Map Poster

      The latest SQL Server 2008 R2 systems views map poster is available here: 2008 R2 Poster It’s available in a pdf or xps format so have fun with it.   Andy
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on December 8, 2010
  • Updates for Some 2008 Tools

    There have been a few releases over the last few days for some SQL Server 2008 tools that you may be interested in. The first one is the 2008 R2 Best Practices Analyzer found here: http://blogs.msdn.com/b/sqlreleaseservices/archive/2010/06/19/sql-server-2008-r2-best-practices-analyzer-is-now-available.aspx And the second one is the 2008 R2 ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on June 19, 2010
  • What time do you have?

    The way in which SQL Server has treated Time has been a very misunderstood subject for as long as I can remember. The largest part of that was the fact that SQL Server was only accurate to 3.33ms. I would like to point you to an excellent article on this and other details surrounding Datetime in SQL Server by Tibor Karaszi found here:  ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on December 20, 2008
  • 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