in

SQL Server Blogs

Voices from the UK SQL Server Community

Browse by Tags

  • 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
  • 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 requirements. The table is build as the following...
    Posted to Piotr Rodak (Weblog) by Piotr Rodak on Mon, Jan 4 2010
Page 1 of 1 (2 items)
Powered by Community Server (Commercial Edition), by Telligent Systems