in

SQL Server Blogs

Voices from the UK SQL Server Community
All Tags » T-SQL » practices (RSS)

Browse by Tags

  • COLUMNS_UPDATED() for audit triggers

    In SQL Server 2005, triggers are pretty much the only option if you want to audit changes to a table. There are many ways you can decide to store the change information. You may decide to store every changed row as a whole, either in a history table or as xml in audit table. The former case requires...
    Posted to Piotr Rodak (Weblog) by Piotr Rodak on Wed, Apr 28 2010
  • Coding standards

    This post will be about coding standards. There are countless articles and blog posts related to this topic, so I know this post will not be too revealing. Yet I would like to mention a few things I came across during my work with the T-SQL code. Naming convention - there are many of them obviously....
    Posted to Piotr Rodak (Weblog) by Piotr Rodak on Thu, Mar 11 2010
  • relative query cost not accurate when using set rowcount

    When tuning performance of a query, it is quite common to compare different variants of the query in the same batch and compare the execution plans to see if changes that you made actually work for better or not. Often you would compare just relative cost of execution plan of a query within the batch...
    Posted to Piotr Rodak (Weblog) by Piotr Rodak on Wed, Jan 27 2010
  • Makesafe script - set up security for developers

    I worked yesterday on a script that is supposed to run on DEV database after it has been restored from production. This script adjusts configuration data and security in the database so developers can work safely on production data without compromising security policies. The original script has a long...
    Posted to Piotr Rodak (Weblog) by Piotr Rodak on Sat, Oct 24 2009
Page 1 of 1 (4 items)
Powered by Community Server (Commercial Edition), by Telligent Systems