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
不具合の修正
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.