SQL Toolbelt Essentials - Incluye SQL Prompt v9.4

SQL Prompt añade capacidad para corregir automáticamente los problemas de análisis de código ST006 en el script.
Octubre 25, 2018
Nueva versión

Características

New 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

Correcciones

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.
SQL Toolbelt Essentials - Incluye SQL Prompt v9.4
SQL Toolbelt Essentials

SQL Toolbelt Essentials

Herramientas galardonadas para comparación de base de datos, productividad, control de código fuente y solución de problemas.

Solicitar presupuesto Comprar ahora

¿Alguna pregunta?

Chatee en vivo ahora mismo con nuestros especialistas en licencias de Redgate Software.