Jason Hall explores whether having the persisted version store on the database as a result of using Accelerated Database Recovery in SQL Server 2019 changes how the version store in tempdb is used for triggers.
Kevin Kline recaps a webinar with the SQLskills team, where they discussed their top SQL Server troubleshooting horror stories and the lessons learned.
Continuing his treatment of NULLs in SQL Server, Itzik Ben-Gan covers how SQL Server's implementation of unique constraints differs from the standard, and how you can work around it.