次の方法で共有

SQL Server 2017 available for download

  • [アーティクル]

Final version of SQL Server 2017 is available for download. New version of SQL Server has a lot of enhancements compared to the previous version.

In this post will be highlighted some of the new features that are available:

Cross-platform support - you can run SQL Server 2017 on Windows, Linux, and Docker containers.

Built-in intelligence - SQL Server supports Python and native scoring using PREDICT function.

T-SQL Language enhancements - There are several enhancements in T-SQL language such as graph processing, new string functions (TRIM, TRANSLATE, CONCAT_WS), and aggregate (STRING_AGG) new Japanese collations that are unique in database market.

Intelligent query processing - Automatic tuning continuously monitors query performance and forces previous plans if some performance regression is detected. Execution of Multi-statement Table value functions is faster thanks to the interleaved execution. Batch mode processing now includes adaptive join operators and leverages memory grant feedback information to execute plans more efficiently.

Column-store enhancements - Clustered columnstore indexes support LOB types and enable you to compress your NVARCHAR(MAX), VARCHAR(MAX) and VARBINARY(MAX) columns up to 25x ratio, non-persisted computed columns enable you to put calculated expressions directly in table definitions,  NONCLUSTERED COLUMNSTORE indexes support online build/rebuild.

In-memory OLTP  enhancements - Memory optimized tables now support computed columns, naively compiled modules support new string and JSON functions, CASE statement, and WITH TIES.

Native import enhancements - BULK INSERT and OPENROWSET enable you to and to load files from Azure Blob Storage. Also, import functions are able to parse real CSV files and correctly process quoted characters.

Better monitoring - Query Store now provides you information about wait stats and a lot of new DMVs are added.

These are just some of the new features that are available in SQL Server 2017. You can find more information about new features in SQL Server 2017 here.

Comments

  • Anonymous
    October 04, 2017
    Thank you for this release.
    • Anonymous
      October 04, 2017
      But it is better to release SQL Server every 5 years to put less pressure on DBA guys. We are currently using SQL Server 2008 R2 and SQL 2012,2014,2016,2017 are already out.
  • Anonymous
    October 05, 2017
    Spell/grammar check needed.
  • Anonymous
    October 05, 2017
    >In-memory OLTP enhancements – Memory optimized tables now support computed columns, naively compiled modules support new string and JSON functions, CASE statement, and WITH TIES.Did you mean, "natively" here instead of naively?
  • Anonymous
    October 10, 2017
    And still no dark theme?
  • Anonymous
    October 15, 2017
    AdventureWorks2016CTP3 does not install on my SSMS it only does AdventureworksDW2016CTP3. I keep getting 3414 error.
  • Anonymous
    October 15, 2017
    Restarting SQL Server 2017 via services snap-in fails after computer start/reboot:Windows could not stop the SQL Server (MYINSTANCE) service on Local Computer.Error 1053: The service did not respond to the start or control request in a timely fashion.However, after ending the SQL Server 2017 process via task manager and starting the service again, restarting the service via services snap-in succeeds.--Connecting to SQL Server 2017 using (local) in the connection string ('Server=(local);Database=master;Integrated Security=SSPI;') fails:"A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)"
  • Anonymous
    October 18, 2017
    The comment has been removed