Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: Swiss Cheese!

    The Cursor has massive overhead.

    Have you considered CTE and Ranking functions in a set based operation:

    Ideally have an Index:

    CREATE CLUSTERED INDEX idx_ID ON MyDB.dbo.Employees(ID);

    Create a CTE that assigns...

Viewing post 1 (of 1 total)