Even by today’s standards FoxPro’s indexing is still impressive.
Calvin Hsia shows details about the indexing and compression techniques used in FoxPro indexes.
Collection of links and articles for future reference
Links to blog posts and topics I wish to revisit in the future.
Dan Sullivan shows how to use Common Table Expressions to query hierarchical data in SQL Server 2005. Hierarchical queries combine recursive SELECT commands to provide the functionality to query self-referencing data.
Hierarchical queries are useful in HR apps for employee->boss representation, in financial applications for accounts chart hierarchy and in inventory applications where parts can be assembled from other parts.