May, 2009

  • Vijay

    SQL Server Workers never yield

    • 1 Comments
    SQL Server scheduler/worker is dsigned such that they are Cooperative and the scheduler expects that the workers yield cooperative. However, the API calls such as External modules, Extended procedures etc. may never yield and as a result the worker will...
  • Vijay

    Deadlock because of Indexed Views

    • 2 Comments
    Indexed views can cause deadlock when two or more of the participating tables (in the indexed view) is updated/inserted/deleted from two or more sessions in parallel such that they block each other causing a deadlock scenario. The deadlock scenario...
Page 1 of 1 (2 items)