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 » Tips & Tricks   (RSS)
  • SQL Server DML Triggers - Tips & Tricks - Part 3 ("Trigger debug")

    This is the third blog post in the series dedicated to the Tips and Tricks of DML Triggers development. The first and the second parts can be found here: SQL Server DML Triggers - Tips & Tricks - Part 1 (''Intro'' & ''Triggers activation order'') SQL Server DML Triggers - Tips & Tricks - Part 2 (''Thought to work on ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on March 21, 2015
  • SQL Server DML Triggers - Tips & Tricks - Part 2 ("Thought to work on multiple rows")

    This is the second blog post in the series dedicated to the Tips and Tricks of DML Triggers development. The first part can be found here: SQL Server DML Triggers - Tips & Tricks - Part 1 (''Intro'' & ''Triggers activation order'').   Triggers must be thought to work on multiple rows One of the most frequent mistake I have seen ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on March 5, 2015
  • SQL Server DML Triggers - Tips & Tricks - Part 1 ("Intro" & "Triggers activation order")

    This is the first blog post in a series of posts about Tips & Tricks of SQL Server DML Triggers. Introduction Triggers are often one of the main reason of quarrel between Developers and DBAs, between those who customize a database application and those who provides it. They are often the first database objects to be blamed when the ...
    Posted to Sergio Govoni (Weblog) by Sergio Govoni on December 29, 2014
  • sp_spaceused Alternative

            I don’t know why but for some reason I have never liked using sp_spaceused. It probably started a long time ago when the results were often inaccurate due to the meta data being out of date. I am pretty sure that was fixed somewhere along the line but the system stored procedure had some other limitations ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on May 17, 2013
  • Backup File Naming Convention

    I have been asked this many times before and again just recently so I figured why not blog about it. None of this information outlined here is rocket science or even new but it is an area that I don’t think people put enough thought into before implementing.  Sure everyone choses some format but it often doesn’t go far enough in my opinion ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on October 5, 2012
  • Speaking in Raleigh NC June 15th

    Just a heads up to those in the area that I will be speaking at the (TriPASS) Raleigh SQL Server user group on the 15th of June 2010. The topic is Storage & I/O Best Practices. The abstract is listed below: SQL Server relies heavily on a well configured storage sub-system to perform at its peak but unfortunately this is one of the most ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on June 2, 2010
  • Cleaning up Un-Named Defaults

    I just had a situation in which we are automating the comparing of databases and I came across a bunch of Defaults that were never explicitly named. This causes them to get a new name each time you create them and makes it much more difficult to write future update scripts when you don’t know the actual name it will be. In any case I decided to ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on June 26, 2009
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement