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 » Best Practices » SQL Techniques   (RSS)
  • disallow results from triggers

    A setting that I noticed a while back when looking at sys.configurations was disallow results from triggers.  Triggers are one of my favorite subjects, and you will find a lot of good uses of them in my book (triggers are also well named, as poor usage of them will allow you to shoot your foot off in a heartbeat as I discussed in my earlier ...
    Posted to Louis Davidson (Weblog) by drsql on June 6, 2009
  • Commenting your code

    As I am easing back into real life from writing the book, I am in search of easy targets for blogging.  My boss mentioned this blog over on Jeff Atwood's Coding Horror Blog and it got me thinking about commenting.  His advice is to only comment "why" the code works.  I can't quite agree, because the code he claims to be ...
    Posted to Louis Davidson (Weblog) by drsql on July 30, 2008
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement