script,practices - Piotr Rodak

28 April 2010 23:27

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...

Posted by Piotr Rodak | 2 comment(s)

Filed under: tips and tricks, t-sql, Numbers table, util, script, practices, programming

11 March 2010 22:07

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...

Posted by Piotr Rodak | 3 comment(s)

Filed under: tips and tricks, t-sql, source code, script, practices, programming, troubleshooting

27 January 2010 22:33

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...

Posted by Piotr Rodak | 1 comment(s)

Filed under: tips and tricks, t-sql, source code, script, practices, concurrency, troubleshooting

Piotr Rodak

This Blog

Syndication

Search

Tags

Navigation

Archives

Browse by Tags

COLUMNS_UPDATED() for audit triggers

Coding standards

relative query cost not accurate when using set rowcount