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...
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 databases that process transactions at a...
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....
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 write basic SQL queries. There are many...
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...
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 fast. Therefore, a tool for tracking...
3 Nasty I/O Statistics That Lag SQL Query Performance
“But it ran fine on our development server!” How many times did I hear it when SQL query...
