Temporal table syntax, ledger table types, memory-optimized limitations, indexed views, partition switching — tricky design scenarios!