Replacing SQL Cursors with Alternatives to Avoid Performance Issues
In this article, we’ll look at some alternatives to using SQL cursors which can help...
Basics of sys.dm_exec_requests
Performance monitoring and troubleshooting in SQL Server is a vast topic. In SQL Server 2005, dynamic management views, also known as...
Consolidating SQL Server Instance by Clustering and Stacking
NOTES: Windows Failover Clustering comprising two nodes. Two SQL Server Failover Cluster Instances. This configuration optimizes the...
SQL Server Database Scoped Configurations and Automatic Plan Correction
In this article, we will examine Database Scoped Configurations and SQL Server 2017 Automatic Plan...
Azure SQL Database Automatic Tuning
Microsoft has recently announced an incredible new feature – automatic tuning in Azure SQL Database. To be honest, I am thoroughly...
Using Indexes in SQL Server Memory-Optimized Tables
Introduction In this article, we will discuss how different types of indexes in SQL Server memory-optimized tables affect performance. We...
Example of Improving Query Performance with Indexes
In this article, we’ll look at how an index can improve the query performance. Indexes in Oracle...
Implementing a Common MS SQL Server Performance Indicator
Introduction There is often a need to create a performance indicator that would show database activity related to the previous period or...
Performance of Table Variables in SQL Server
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...
Query Optimization in PostgreSQL. EXPLAIN Basics – Part 3
I continue a series of articles on the basics of EXPLAIN in PostgreSQL, which is a short review of...
