Browse by Tags

All Tags » practices (RSS)
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: , , , , , ,
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: , , , , , ,
24 October 2009 13:35

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...
Posted by Piotr Rodak | with no comments
Filed under: , , , , ,