This blog will no longer be updated.

New content is available on my new blog

troubleshooting,concurrency - Piotr Rodak

Browse by Tags

All Tags » troubleshooting » concurrency (RSS)

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

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