SQL Toolbelt Essentials - Includes SQL Prompt v9.4

SQL Prompt는 스크립트에서 ST006 코드 분석 이슈를 자동으로 수정하는 기능을 추가합니다.
10월 25, 2018
신규 버전

기능

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

수정사항

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

SQL Toolbelt Essentials

데이터베이스 비교, 생산성, 소스 컨트롤 및 문제 해결을 위한 수상 경력을 가진 툴.

견적 요청 지금 구입하기

궁금한 점이 있으세요?

Redgate Software 사 제품 라이선스 담당자와 라이브 채팅