troubleshooting - Piotr Rodak

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

04 January 2010 22:10

updlock, holdlock and deadlocks

We have a process that manages sliding window over a number of tables in our reporting database. This process is triggered by first call to our reporting ETL. There is table that contains two dates that are important for the partitioning and business...

Posted by Piotr Rodak | 1 comment(s)

Filed under: t-sql, performance, trace flags, deadlocks, concurrency, troubleshooting, locking hits

Piotr Rodak

This Blog

Syndication

Search

Tags

Navigation

Archives

Browse by Tags

Coding standards

relative query cost not accurate when using set rowcount

updlock, holdlock and deadlocks