Гость
Форумы / Microsoft SQL Server [игнор отключен] [закрыт для гостей] / Cumulative Update 5 for SQL Server 2019 / 2 сообщений из 2, страница 1 из 1
22.06.2020, 22:47
    #39972085
Александр Гладченко
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Cumulative Update 5 for SQL Server 2019
...
Рейтинг: 0 / 0
23.06.2020, 15:08
    #39972437
Александр Гладченко
Участник
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Cumulative Update 5 for SQL Server 2019
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
Форумы / Microsoft SQL Server [игнор отключен] [закрыт для гостей] / Cumulative Update 5 for SQL Server 2019 / 2 сообщений из 2, страница 1 из 1
Целевая тема:
Создать новую тему:
Автор:
Найденые пользователи ...
Разблокировать пользователей ...
Читали форум (0):
Пользователи онлайн (0):
x
x
Закрыть


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