SQL Shack

MAY 27, 2019

Introduction to SQL Server Statistics SQL Server Statistics are an essential part of query performance in SQL Server. If we do not have updated statistics, it might lead to resource intensive query execution plan. For example, for […].

Servers 53

Servers Availability Performance 53

Dynatrace

SEPTEMBER 8, 2023

Notably, the SQL query is not limited to specific columns or data with specific metric values (int or float). Once the data is received in Grail, you can explore, manipulate, and analyze the data, utilizing advanced techniques such as filtering, grouping and aggregation, calculations and transformations, time windowing, and much more.

Database 269

Database Artificial Intelligence Metrics Monitoring 269

Percona

JULY 27, 2023

MySQL previously released software quarterly as part of a continuous delivery system where new features were made available. is an evolution of the MySQL server and related software. is an evolution of the MySQL server and related software. This is a Quick Peek at what Oracle delivered with MySQL 8.0.34 on July 17th, 2023.

Servers 81

Servers Open Source Tuning Cache 81

SQL Performance

FEBRUARY 10, 2021

I’ll do my testing in tempdb, enabling IO and TIME statistics: SET NOCOUNT ON ; USE tempdb ; SET STATISTICS IO , TIME ON ; The fastest solution from last month applies a join with a dummy table that has a columnstore index to get batch processing. There were no I/O operations involved in those solutions. BatchMe ON 1 = 0.

C++ 124

C++ Servers Testing Code 124

SQL Performance

MARCH 17, 2020

This follow-up post revisits the question for SQL Server 2019, using a larger number of rows. It has 32GB RAM, with 24GB available to the SQL Server 2019 instance. Automatically-created sampled statistics on the BountyAmount column were created on the first run. Test Environment. Row Store Clustered Index.

Servers 86

Servers Tuning Database Efficiency 86

SQL Performance

SEPTEMBER 25, 2019

To be clear, this difference is about execution plan operators , not T-SQL query syntax. Performance spools always appear on the inner side (the lower input in graphical execution plans) of a nested loops join or apply operator. The Lazy Index Spool operator is only available with apply. lower row): General remarks.

Performance 104

Performance Cache Servers Education 104

SQL Performance

MARCH 8, 2021

SQL Server 2014 SP2 and later produce runtime (“actual”) execution plans that can include elapsed time and CPU usage for each execution plan operator (see KB3170113 and this blog post by Pedro Lopes). Interpreting these numbers is not always as straightforward as one might expect. Compatibility level 150 is used exclusively.

Servers 95

Servers Tuning Architecture Processing 95