SQL Server 2017 MERGE statement assertion error when database is in simple recovery model.
This appears to be identical to an earlier issue with MERGE statements in SQL Server 2014 and 2016, and to feedback closed for SQL Server 2016:
When running a MERGE statement against a data warehouse database in simple recovery model, we receive the following fatal error: SQL Server Assertion: File: <pageref.cpp>, line=1496 Failed Assertion = 'IS_OFF (BUF_MINLOGGED, m_buf->bstat) || pageModifyType != PageModifyType_Contents || GetPagePtr ()->IsTextPage ()'.
We are running SQL Server 2017 Standard Edition with CU6 (14.0.3025.34).
A workaround for the assertion error is to set trace flag 692 which disables fast load.
Stijn De Sloovere commented
Same on Microsoft SQL Server 2017 Enterprise 14.0.3038.14 (X64)
Same on SQL 2017 Enterprise 14.0.3026.27