MySQL Create Index Guide: How to Add and Optimize Indexes for Performance
Have you thought of how big a deal is to create an index in MySQL? Using it enough vs. not...
How to Use AI for SQL Tuning for a Real Automated Process
The rapid evolution in development from rigidly structured data to responsive, flexible databases allows database administrators (DBAs) to...
SQL Server Transactional Replication Issues
We started talking about SQL Server Transactional Replication issues earlier. Now, we are going to continue with a few more hands-on demos...
A Simple Use Case for Indexes on Primary Keys
Introduction Recently we encountered an interesting performance problem on one of our SQL Server...
MS SQL Server on Linux vs Windows Performance Test to Spot the Difference
Since the release of SQL Server 2017 for Linux, Microsoft has pretty much changed the entire game. It enabled a whole new world of...
Query Optimization Techniques in SQL Server: 5 Best Practices to Boost Queries Performance
What is query optimization in SQL Server? It’s a big topic. Each technique or problem needs a separate article to cover the bases....
9 Best Practices for Writing SQL Queries
If you are reading this article, most probably, you are already familiar with SQL. You know how to...
22 Different T-SQL Indexes Examples to Warp Speed Your Queries
Indexing the database tables is one of the ways to up your game in tuning queries. How do you do it? Today’s post will give you 22 SQL...
How CTE Can Aid In Writing Complex, Powerful Queries: A Performance Perspective
We often see poorly written complex SQL queries running against a table or tables in databases. Those queries make the time of execution...
How To Create SQL Trace To Capture SQL Server Events
Facing an SQL Server performance issue, you need to identify the source of that performance problem...
