Sites Microsoft


What is plan regression in SQL Server?

Publié le 9 juin 2017 sur Microsoft SQL Server database engine blog
 

Plan regression happens when SQL Server starts using the sub-optimal SQL plan to execute some T-SQL query. Usually you will see that some T-SQL query is executing really fast, but then it gets slower without any obvious reason. In this post you will se …

You may see “out of user memory quota” message in errorlog when you use In-Memory OLTP feature

Publié le 7 juin 2017 sur css sql server engineers
 

Recently we got an inquiry from a customer who received the following message in errorlog and wanted to know why. [INFO] HkDatabaseTryAcquireUserMemory(): Database ID: [7]. Out of user memory quota: requested = 131200; available = 74641; quota = 343597 …

Released: Public Preview for SQL Server Management Packs Update (6.7.30.0)

Publié le 30 mai 2017 sur microsoft sql server release services
 

We are getting ready to update the SQL Server Management Packs. Please install and use this public preview and send us your feedback (sqlmpsfeedback@microsoft.com)! We appreciate the time and effort you spend on these previews which make the final prod …

Use WITH clause in OPENJSON to improve parsing performance

Publié le 29 mai 2017 sur Microsoft SQL Server database engine blog
 

OPENJSON function has a WITH clause where you can specify what fields should be extracted from input JSON. This might improve performance of your queries compared to the case where you use OPENJSON without schema and later extract information from the …

Now Available: Guide for enhancing privacy and addressing GDPR requirements with the Microsoft SQL platform

Publié le 24 mai 2017 sur sql server security blog
 

Data privacy and data security have become one of the most prominent topics in organizations in almost every industry across the globe. New regulations are emerging that formalize requirements around these topics, and compel organizations to comply. Th …

Released: Public Preview for SQL Server 2017 Management Pack (CTP3)

Publié le 24 mai 2017 sur microsoft sql server release services
 

We are happy to announce SQL Server 2017 Management Pack CTP3 bits with new features are ready (6.7.55.0). Please install and use this public preview and send us your feedback (sqlmpsfeedback@microsoft.com). On the download page, you will see reference …

Announcing SQL Server 2012 Service Pack 4

Publié le 23 mai 2017 sur microsoft sql server release services
 

The SQL Server team is excited to bring you the last service pack release for SQL Server 2012. SQL Server 2012 Service Pack 4 (SP4) in addition to a rollup of released hotfixes contains 20+ improvements centered around performance, scalability and diag …

Try new SQL Server command line tools to generate T-SQL scripts and monitor Dynamic Management Views

Publié le 17 mai 2017 sur sql server team blog
 

This post was authored by Tara Raj and Vinson Yu, Program Managers – SQL Server Team We are excited to announce the public preview availability of two new command line tools for SQL Server: The mssql-scripter tool enables developers, DBAs, and sy …

SQL Server 2017 CTP 2.1 now available

Publié le 17 mai 2017 sur sql server team blog
 

Microsoft is excited to announce a new preview for the next version of SQL Server (SQL Server 2017). Community Technology Preview (CTP) 2.1 is available on both Windows and Linux. In this preview, we added manageability features to make it easier to co …

SQL Server 2017 on Linux surpasses 1 million Docker pulls as the next preview version rolls out

Publié le 17 mai 2017 sur sql server team blog
 

This post was authored by Rohan Kumar, General Manager, Database Systems Group SQL Server 2017 makes it easier and simpler to work with data, with more deployment options than before and monthly preview releases offering regular innovation and improvem …

Automatic plan correction in SQL Server 2017

Publié le 17 mai 2017 sur Microsoft SQL Server database engine blog
 

Automatic plan correction is a new automatic tuning feature in SQL Server 2017 that identifies SQL query plans that are worse than previous one, and fix performance issues by applying previous good plan instead of the regressed one. When you need a pla …

Keeping freight moving in Denmark with SQL Server 2016

Publié le 16 mai 2017 sur sql server team blog
 

Efficient data management keeps goods flowing smoothly in Denmark. Danske Fragtmaend, the country’s largest national transport and distribution firm, has been moving freight for more than a century. Today, Danske Fragtmaend delivers more than 40, …

SQL Server Command Line Tools for macOS released

Publié le 16 mai 2017 sur sql server team blog
 

This post was authored by Meet Bhagdev, Program Manager, Microsoft We are delighted to share the production-ready release of the SQL Server Command Line Tools (sqlcmd and bcp) on macOS El Capitan and Sierra. The sqlcmd utility is a command-line tool th …

Automatic index management in Azure SQL database

Publié le 16 mai 2017 sur Microsoft SQL Server database engine blog
 

Azure SQL Database has a built-in intelligence mechanism that can automatically tune and improve performance of your queries by dynamically adapting the database schema to your workload. In Azure SQL Database, you don’t need to worry about the in …


Pages :