SP2 includes the hotfixes from all released 2016 cumulative updates: SQL Server 2016 CU1 through SP1 CU8. To get the itemized list of those, you’d need to click through the posts in our 2016 CU listing. Suffice it to say, there were a lot. Here’s some of my favorite new […]
SQL Server 2016 SP1 CU8 has a whole bunch of Analysis Services fixes, plus: Long restore times for encrypted databases Memory leak in sys.dm_exec_cached_plans Deadlocks when inserting into a partitioned clustered columnstore index Dynamic data masking returns invalid data Tempdb contention due to caching problems UPDATE fails silently if you […]
Just in time for your Thanksgiving outage window, Microsoft brings you the latest cumulative update for SQL Server 2016. Some highlights include: Memory use higher with many databases Memory leak when you process updates in SSAS Access violation when you cancel a query Access violation when you run sp_xml_preparedocument Incorrect […]
Good evening, and how are you doing tonight? Welcome to Café Updaté. Tonight, Chef has prepared a delicious menu from the latest, freshest market ingredients. I’ll be back in a few moments to take your drink orders and tell you about the specials, but in the meantime, get comfortable, enjoy […]
A-one, and a-two – here’s Cumulative Update 2, or as they say in Mexico, DOS. The fix list is pretty long, and here’s some of the greatest hits: DML statements unexpectedly replicated to subscribers Query returns incorrect results from nonclustered columnstore index Incorrect results are returned when query contains a […]
Last night, Microsoft unveiled 13.0.2149.0, and it’s a big one. It includes pages and pages of fixes like: Query Store automatic data cleanup was failing on Standard, Express, Eval Editions Fatal error when you query sys.sysindexes if you have memory-optimized tables Memory leak when DATA_CONSISTENCY_CHECK is run on a temporal table […]
In the continuing march towards a final release date, SQL Server 2016 CTP 2.3 is now available for download.