in

SQL Server Blogs

Voices from the UK SQL Server Community
All Tags » T-sql » source code (RSS)

Browse by Tags

  • The penultimate audit trigger framework

    So, it’s time to see what I came up with after some time of playing with COLUMNS_UPDATED() and bitmasks. The first part of this miniseries describes the mechanics of the encoding which columns are updated within DML operation. The task I was faced with was to prepare an audit framework that will be fairly...
    Posted to Piotr Rodak (Weblog) by Piotr Rodak on Tue, May 11 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

  • updating column with a random value

    I have been working recently on load testing of our ETL. One of the factors that determines amount of transfered data is a lookup table that is joined to the source. I populated this table with aproppriate values, and then realized that I also need some values in second column, and they were null. Let's...
    Posted to Piotr Rodak (Weblog) by Piotr Rodak on Wed, Jan 13 2010

  • on update cascade...

    When you define a foreign key constraint, you can also decide what SQL Server should do when primary key to which the constraint references to gets deleted or updated. While I always knew and imagined that ON DELETE CASCADE may be useful, I wondered, what scenarios would be suitable for ON UPDATE CASCADE...
    Posted to Piotr Rodak (Weblog) by Piotr Rodak on Thu, Sep 24 2009

  • Sql release builder

    For a number of weeks, we have been regularly releasing code to our UAT database. The release process of database code differs slightly from releasing binary code because the release has to take into account existing data and schema in the database. With binary code (as in C# application) usually old...
    Posted to Piotr Rodak (Weblog) by Piotr Rodak on Mon, Jul 20 2009
Page 1 of 1 (6 items)
Powered by Community Server (Commercial Edition), by Telligent Systems