Database Questions from Las Vegas

Brent Ozar is in Las Vegas, working through viewers' top-voted questions submitted at pollgab.com/room/brento. This episode covers HADR_SYNC_COMMIT waits behind Always On availability group outages, whether to index valid_to or valid_from in temporal tables, enabling RCSI without introducing concurrency bugs, comparing SQL Server with MySQL, PostgreSQL, and Oracle, whether SQL Server 2025 is safe to adopt yet, finding the queries eating your TempDB space, and choosing between a filtered index...