You are here:   Blog
Register   |  Login

Blog Archive:

* Can be used in order to search for older blogs Entries

Search in blogs

Blog Categories:

* Can be used in order to search for blogs Entries by Categories

Blog Tags:

* Can be used in order to search for blogs by keywords


Awared MVP 

Microsoft® Community Contributor 

Microsoft® Community Contributor

Read first, before you you use the blog


Written by: ronen ariely
17/02/2018 05:24 RssIcon

SQL Server Management Studio 17.5 was released yesterday

Be the first to update to the new version!

let me summarize the new features which were added to SQL Server Management Studio (SSMS) version 17.5

>> SQL Data Discovery and Classification (DC): a reposting tool that help discover, classify, label, and report sensitive data columns in databases. The tool scans the database automatically and gives us the recommendation for classifying and labeling columns. It allows us to selects from the recommendation or add costume classification and labels to columns. Once we select the columns which we want to classify and label we can produce a report. This tool compatible with the European new General Data Protection Regulation (GDPR), and can be very useful to improve data security.

>> Added support for SkipRows option to the Delimited Text External File Format for Azure SQL DW.

>> Cumulative Update 3 of SQL Server 2017 added two new execution statistics attributes to QueryTimeStats: (1) UdfCpuTime and (2) UdfElapsedTime, which provide the total CPU and elapsed time that is spent inside scalar user-defined functions. SSMS 17.5 added the support for these.

SQL Server query optimizer provides the concept of a ‘row goal’, when the query plan is optimized to find the first matching row(s) quickly. This works on row-limited queries (queries that contain TOP, OPTION (FAST N), IN, or EXISTS keywords).

SQL Server 2016 Service Pack 1 added new hint DISABLE_OPTIMIZER_ROWGOAL (act like Trace Flag 4138), which disable the mechanism of Row Goals. More information regarding Ros Goal can be find here .
SQL Server 2017 CU3 added the new query execution plan attribute
EstimateRowsWithoutRowGoal , which allows to compare it to the EstimateRows attribute, in order to see how much row goal affects the Query Optimizer estimates.

SSMS 17.5 adds the support of EstimateRowsWithoutRowGoal in the execution plan.

>> Enabled display of estimated plan button for Azure SQL Data Warehouse

Tags: SQL , SSMS
Categories: SQL
Location: Blogs Parent Separator Public blog