Thursday, June 22, 2017
 
Updates from Storage Engine Team @ Microsoft
Facebook Twitter LinkedIn Google+ Addthis

Get Aggregated RSS

Azure SQL databases in logical servers, elastic pools, and managed instances

Tuesday, June 13, 2017

Azure SQL Database is a Database as a Platform service designed for applications that will use database as self-contained service. Databases can be grouped together to simplify management options or share the resources. There are different options that can be used to bound databases in the groups, which will be explained in this post. Databases... Read more

What is plan regression in SQL Server?

Friday, June 09, 2017

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 see how can plan regression happen. Setup First I’m going to create a... Read more

Use WITH clause in OPENJSON to improve parsing performance

Monday, May 29, 2017

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 parsed JSON using JSON_VALUE function. I have found some examples where people using OPENJSON... Read more

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

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