Contiguous Ranges of primary keys: a more cross platform and faster approach

(Leo Hsu and Regina Obe) In last article Finding Contiguous primary keys we detailed one of many ways of finding continuous ranges in data, but the approach would only work on higher-end dbs like Oracle 11G, SQL Server 2012, and PostgreSQL 8.4+. Oracle you’d have to replace the EXCEPT I think with M

Read More - Register for Free Membership