New cumulative update for SQL Server 2017

Microsoft has just release an cumulative update for SQL Server 2017 CU 23.

I am always interested in fixes to DBCC CHECKDB and DBCC CHECKTABLE. There was one fix related to CHECKTABLE that fixes an issue where the session gets killed when you run DBCC CHECKTABLE with PHYSICAL_ONLY due to disk full. The session remains in KILLED\ROLLBACK state and threads are waiting on CHECK_TABLES_THREAD_BARRIER wait type with increasing wait time.

There was a fix around the MERGE statement failing. A number of fixes around memory optimzied tables.

There was a fix in replication where newly added articles snapshot doesn’t get applied to the subscriber. Good to know if you are doing a lot with replication.

As usual the recommendation is to keep up to date on your SQL Server updates, but not too up to date. I will usually test the CU’s in a dev environment and give them at least 2 weeks before pushing them to a production server.

More from Stedman Solutions:

Steve and the team at Stedman Solutions are here for all your SQL Server needs.
Contact us today for your free 30 minute consultation..
We are ready to help!