powered by simpleCommunicator - 2.0.53     © 2025 Programmizd 02
Форумы / Microsoft SQL Server [игнор отключен] [закрыт для гостей] / Cumulative Update 5 for SQL Server 2019
2 сообщений из 2, страница 1 из 1
Cumulative Update 5 for SQL Server 2019
    #39972085
Фотография Александр Гладченко
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
...
Рейтинг: 0 / 0
Cumulative Update 5 for SQL Server 2019
    #39972437
Фотография Александр Гладченко
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
SQL Server 2019 Cumulative Update 5: A Box of Chocolates

Quick rundown of some of the issues:

  • “Fix:” Scalar UDF inlining issues – this KB article keeps getting expanded with each CU, but here’s the weird part: they’re not actually fixing the issues. They’re just disabling inlining in more queries. Hmm.
  • Fix: blocking may occur when Reduce Recompilations feature is enabled by default – I’ve tried wrapping my head around that title a few times
  • Improvement: TDE backup encryption setting changes – changes like this are a good reminder of why you gotta read every KB article now when you’re doing upgrades, because you might just have work to do even if you weren’t expecting it. Now you need to take a gander at your backup settings.
  • Corruption caused by shrinking a database – boy, they worked really hard to avoid using the word corruption here: “When shrinking a database, you may receive a database consistency error if the shrinking process encounters an IAM page that is the first and only IAM page. The symptoms may include assertions errors involving heapdataset. Confirm that you do not have any inconsistencies by executing DBCC CHECKDB after shrink operations. Applying this update will prevent future occurrence of this issue and not clean up past inconsistencies.”
  • Accelerated Database Recovery is not supported for databases using mirroring – I really liked the sound of ADR when it came out, but there have been some head-shaking bugs in this one.
...
Рейтинг: 0 / 0
2 сообщений из 2, страница 1 из 1
Форумы / Microsoft SQL Server [игнор отключен] [закрыт для гостей] / Cumulative Update 5 for SQL Server 2019
Целевая тема:
Создать новую тему:
Автор:
Закрыть
Цитировать
Найденые пользователи ...
Разблокировать пользователей ...
Читали форум (0):
Пользователи онлайн (0):
x
x
Закрыть


Просмотр
0 / 0
Close
Debug Console [Select Text]