Perfomance Tuning

Basics of sys.dm_exec_requests

16:24 Database administation, Perfomance Tuning

Performance monitoring and troubleshooting in SQL Server is a vast topic. In SQL Server 2005,...
Read More

Consolidating SQL Server Instance by Clustering and Stacking

18:41 Database administation, Perfomance Tuning

NOTES: Windows Failover Clustering comprising two nodes. Two SQL Server Failover Cluster Instances. This configuration optimizes the...
Read More

SQL Server Database Scoped Configurations and Automatic Plan Correction

13:32 Automation, Database administation, Perfomance Tuning

In this article, we will examine Database Scoped Configurations and SQL Server 2017 Automatic Plan Correction. Microsoft added new features...
Read More

Azure SQL Database Automatic Tuning

17:34 Automation, Database administation, Perfomance Tuning

Microsoft has recently announced an incredible new feature – automatic tuning in Azure SQL...
Read More

Using Indexes in SQL Server Memory-Optimized Tables

12:49 Database administation, Database development, Indexes, Memory Optimization, Perfomance Tuning

Introduction In this article, we will discuss how different types of indexes in SQL Server memory-optimized tables affect performance. We...
Read More

Example of Improving Query Performance with Indexes

13:38 Database administation, Database development, Indexes, Perfomance Tuning

In this article, we’ll look at how an index can improve the query performance. Introduction  Indexes in Oracle and other databases...
Read More

Implementing a Common MS SQL Server Performance Indicator

16:05 Database administation, Perfomance Tuning

Introduction There is often a need to create a performance indicator that would show database...
Read More

Performance of Table Variables in SQL Server

10:03 Database administation, Database development, Perfomance Tuning, Tables

In this article, we are going to touch upon the topic of performance of table variables. In SQL Server, we can create variables that will...
Read More

Query Optimization in PostgreSQL. EXPLAIN Basics – Part 3

13:08 Database administation, Perfomance Tuning

I continue a series of articles on the basics of EXPLAIN in PostgreSQL, which is a short review of Understanding EXPLAIN by Guillaume...
Read More

Why Multiple JOINs are bad for Query or Do Not Get in the Way of Optimizer

08:52 Database administation, Perfomance Tuning, SQL Server

Recently, I came across an application that generated DB queries. I understand that there is...
Read More