Todays installment covers update performance. As slow as insert and delete together, but sometimes still faster.
Feb
09
2012
09
2012
--
Window-Functions for Pagination
Todays installment finalizes the Chapter on partial results and shows how to use SQL:2003 window-Functions for an offset-based pagination query in SQL Server and Oracle.