Tuesday, May 23, 2017
 
Updates from Storage Engine Team @ Microsoft
Facebook Twitter LinkedIn Google+ Addthis

Get Aggregated RSS

Automatic plan correction in SQL Server 2017

Wednesday, May 17, 2017

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 plan correction? SQL Server can use different strategies (or SQL plans) to execute... Read more

Automatic index management in Azure SQL database

Tuesday, May 16, 2017

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 index analysis and design, because Azure SQL Database learns about your workload and ensures that your data... Read more

“You Shall Not Regress!!!” – How SQL Server 2017 prevents plan regressions?

Tuesday, April 25, 2017

SQL plan regression is a case when a T-SQL query that executed fine becomes much slower or uses more resources because the underlying SQL plan changed. SQL Server 2017 would not allow that kind of regressions if you enable new automatic tuning feature on your database. What is plan regression? Imagine that you execute the... Read more

How to find query plan choice regressions with SQL Server 2017 CTP2

Monday, April 24, 2017

SQL Server 2017 in CTP2.0  version automatically identifies potential performance regressions in SQL queries, enables you to easily find potential issues, and gives you information what should you do to fix the issue. In CTP2.0 version is added new system view sys.dm_db_tuning_recommendations that returns recommendations that you can apply to fix potential problems in your database.... Read more

Introducing Interleaved Execution for Multi-Statement Table Valued Functions

Wednesday, April 19, 2017

For SQL Server vNext and Azure SQL Database, the Microsoft Query Processing team is introducing a new set of adaptive query processing improvements to help fix performance issues that are due to poor cardinality estimates. Improvements in the adaptive query processing space include batch mode memory grant feedback, batch mode adaptive joins, and interleaved execution. ... Read more

Introducing Batch Mode Adaptive Joins

Wednesday, April 19, 2017

For SQL Server 2017 and Azure SQL Database, the Microsoft Query Processing team is introducing a new set of adaptive query processing improvements to help fix performance issues that are due to inaccurate cardinality estimates. Improvements in the adaptive query processing space include batch mode memory grant feedback, batch mode adaptive joins, and interleaved execution. ... Read more

Comparing performance of data access libraries using StackExchange/Dapper benchmark

Tuesday, March 14, 2017

One of the most important questions that you need to answer in your projects is what data access library you should use to access your data in SQL Server database. One of the benchmarks that you can use is StackExchange Dapper benchmark that checks how fast could different data access libraries fetch a single row from... Read more

Loading files from Azure Blob Storage into Azure SQL Database

Thursday, February 23, 2017

Azure SQL Database enables you to directly load files stored on Azure Blob Storage using the BULK INSERT T-SQL command and OPENROWSET function. Loading content of files form Azure Blob Storage account into a table in SQL Database is now single command: BULK INSERT Product FROM 'data/product.dat' WITH ( DATA_SOURCE = 'MyAzureBlobStorageAccount');   BULK INSERT is... Read more

SQL Server 2016 Developer Edition in Windows Containers

Tuesday, February 21, 2017

We are excited to announce the public availability of SQL Server 2016 SP1 Developer Edition in Windows Containers! The image is now available on Docker Hub and the build scripts are hosted on our GitHub repository. This image can be used in both Windows Server Containers as well as Hyper-V Containers. SQL Server 2016 Developer... Read more

Parsing 4GB JSON with SQL Server

Tuesday, February 14, 2017

SQL Server 2016 and Azure SQL Database enable you to parse JSON text and transform it into tabular format. In this post, you might see that JSON functions can handle very large JSON text – up to 4GB. First, I would need very large JSON document. I’m using TPCH database so I will export the... Read more

HOME   |   SQL ARTICLES   |   SCRIPTS   |   DISCUSSIONS   |   SQL TEAMS   |   JOBS   |   ABOUT US
Copyright [2014] by SQLCOMMUNITY.COM