Released: Oct 17, 2018

October 2018 release II 中的更新

特性

Updates in SQL Monitor 8.0.20

• Preview - New Backup and SQL Agent Job pages have been added to the estate tab.
• Installed versions now shows GDRs as well as CUs and SPs.

Updates in SQL Prompt 9.4

• You can now automatically fix ST006 code analysis issues in your script:
  • Issues that are fixable are represented by an orange lightbulb icon in the sidebar, rather than the traditional blue one.
  • Clicking on the lightbulb will show the issue details pane, which when applicable, will contain a button labeled "Apply Fix".
  • Clicking this button will automatically fix the relevant issue in the script.
• Added auto completion for the following query hints:
  • KEEP UNION
  • MAX_GRANT_PERCENT
  • MIN_GRANT_PERCENT
  • NO_PERFORMANCE_SPOOL
  • QUERYTRACEON
  • SHRINKDB PLAN
• Added auto completion for the following query USE HINTS:
  • ASSUME_MIN_SELECTIVITY_FOR_FILTER_ESTIMATES
  • DISABLE_BATCH_MODE_ADAPTIVE_JOINS
  • DISABLE_BATCH_MODE_MEMORY_GRANT_FEEDBACK
  • DISABLE_INTERLEAVED_EXECUTION_TVF
  • QUERY_OPTIMIZER_COMPATIBILITY_LEVEL_100
  • QUERY_OPTIMIZER_COMPATIBILITY_LEVEL_110
  • QUERY_OPTIMIZER_COMPATIBILITY_LEVEL_120
  • QUERY_OPTIMIZER_COMPATIBILITY_LEVEL_130
  • QUERY_OPTIMIZER_COMPATIBILITY_LEVEL_140
  • QUERY_OPTIMIZER_COMPATIBILITY_LEVEL_150
  • QUERY_PLAN_PROFILE

修补程序

Fixes in SQL Monitor 8.0.20

• Database File Usage alert for Filestreams has been fixed so that it only raises alerts if a max size is set.
• Excluded master database from Differential Backup Alerter, since Differential Backup cannot be performed on master.

Fixes in SQL Prompt 9.4

• Fixed a UI problem in the List of Code Analysis Issues where scrollbars were not clearly visible.
• Formatting certain query hints such as IGNORE_NONCLUSTERED_COLUMNSTORE_INDEX and NO_PERFORMANCE_SPOOL no longer causes a failure.
• Fixed crash that could occur when running 'Find unused variables and parameters', 'Summarize script' or 'Encapsulate as new stored procedure' with T-SQL syntax errors present.