Coding Black Arts

Virtual Indexing Part 9: The Indexed Hierarchy

Turbo-charge your SQL hierarchy with a numbers table.

by Alan Burstein February 9, 2021February 18, 2021

Virtual Indexing Part 8: The Indexed Splitter Function

The fastest way to split a string is to have already done so.

by Alan Burstein February 4, 2021February 7, 2021

Virtual Indexing Part 7: Finite Opposite Numbers

Virtual Indexing continues…How do we to avoid sorting in either direction (ascending and descending)?

by Alan Burstein January 1, 2021January 1, 2021