Performance Tuning

How to Use AI for SQL Tuning for a Real Automated Process

Automation, Database administration, Performance Tuning

The rapid evolution in development from rigidly structured data to responsive, flexible databases...
Read More

SQL Server Transactional Replication Issues

Database administration, Performance Tuning, Transaction Log, Troubleshooting Issues

We started talking about SQL Server Transactional Replication issues earlier. Now, we are going to continue with a few more hands-on demos...
Read More

A Simple Use Case for Indexes on Primary Keys

Database administration, Database development, Indexes, Performance Tuning, SQL Server • 3 Comments

Introduction Recently we encountered an interesting performance problem on one of our SQL Server databases that process transactions at a...
Read More

MS SQL Server on Linux vs Windows Performance Test to Spot the Difference

Database administration, Performance Tuning

Since the release of SQL Server 2017 for Linux, Microsoft has pretty much changed the entire game....
Read More

Query Optimization Techniques in SQL Server: 5 Best Practices to Boost Queries Performance

Database administration, Database development, Performance Tuning, Statements

What is query optimization in SQL Server? It’s a big topic. Each technique or problem needs a separate article to cover the bases....
Read More

9 Best Practices for Writing SQL Queries

Database administration, Database development, MySQL, Oracle, Performance Tuning, PostgreSQL, SQL Server, Statements

If you are reading this article, most probably, you are already familiar with SQL. You know how to write basic SQL queries. There are many...
Read More

22 Different T-SQL Indexes Examples to Warp Speed Your Queries

Database administration, Database development, Indexes, Languages & Coding, Performance Tuning, T-SQL

Indexing the database tables is one of the ways to up your game in tuning queries. How do you do...
Read More

How CTE Can Aid In Writing Complex, Powerful Queries: A Performance Perspective

Database development, Performance Tuning, Tables, Work with data

We often see poorly written complex SQL queries running against a table or tables in databases. Those queries make the time of execution...
Read More

How To Create SQL Trace To Capture SQL Server Events

Database administration, Database development, Events, Performance Tuning

Facing an SQL Server performance issue, you need to identify the source of that performance problem fast. Therefore, a tool for tracking...
Read More

3 Nasty I/O Statistics That Lag SQL Query Performance

Database administration, Performance Tuning • One Comment

“But it ran fine on our development server!” How many times did I hear it when SQL query...
Read More