SQL Server ASYNC_NETWORK_IO Wait Type
Explore the issue of async_network_io wait type and discover how it affects SQL Server performance and user experience.
Performance Tuning
Valuable SQL Server Performance Tuning tips, tutorials, how-to’s, scripts, and more for SQL Server DBAs.
Understanding Query Performance Issues Caused by Local Variables in SQL Server
Learn how using a SQL Server local variable affects query optimization and execution plans with our insightful guide.
Create a SQL Server Baseline
Uncover the importance of a SQL Server baseline. Learn how to gather historical data to optimize your database performance.
SQL Server Table-Valued Parameter Join Issues in Stored Procedures
Learn how table valued parameter joins in SQL Server stored procedures can negatively impact query performance.
A Practical Deep Dive into I/O for T-SQL Performance Tuners
Explore I/O performance in SQL Server and learn how to identify bottlenecks in code and hardware for better query optimization.
Memory Grant Feedback Reduces the Impact of Outdated SQL Server Statistics
Learn how outdated statistics in SQL Server can cause query performance issues with memory and tempdb and what can be done.
SQL Server Table Valued Function Performance Comparison – Multi-Statement vs Inline
Learn how SQL Server Table Valued Function can impact query performance for multi-statement versus inline TVFs.
SQL Server Concurrency Issues with Parallel Query Plans
Learn how SQL Server concurrency can be impacted by parallelism and how it affects query performance in high-demand environments.
Understanding SQL Server PAGEIOLATCH Wait Types
Learn about SQL Server PAGEIOLATCH waits. Discover techniques to address disk I/O delays and improve query performance.
Identify and Mitigate SQL Server High Memory Usage
Learn to tackle SQL Server high memory usage by identifying memory intensive queries and applying effective mitigation techniques.
SQL Query Troubleshooting: Memory Issues and Timeouts
Discover why your SQL query might timeout. Explore common issues and solutions to improve query execution performance.
Optimize SQL Server Query without Changing the Query
Learn how to improve SQL Server query optimization by not rewriting the query and using the proper indexes.
Identify and Mitigate High CPU SQL Server Usage Queries
Learn how to manage SQL Server CPU usage effectively. Discover tips to identify and mitigate high CPU consumption issues.
SQL Parameter Sniffing Fix with a Covering Index
Address SQL parameter sniffing to avoid recurring performance problems using a covering index to solve the problem.
Identify SQL Server Performance Problems Quickly and Efficiently
Enhance your database efficiency with SQL performance tuning. Discover how SQL Grease can identify and resolve issues quickly.
SQL Query Memory Consumption in SQL Server 2025
Explore SQL query memory consumption differences between SQL Server 2022 and SQL Server 2025 in this detailed performance analysis.
SQL Server Memory Optimized Table vs. Temporary Table Performance
In this article, we look at a SQL Server memory optimized table variable versus a temporary table to see what performs better.
Picking the ON or WHERE Clause for the SQL Predicate
In this article, learn how and why SQL results differ based on where we place the SQL predicate filter in the ON or WHERE clause.
Query Performance Degraded After SQL Server Upgrade
In this article, we look at an example of where query performance degraded after migration to SQL Server 2022 and a possible fix.
Identify and Clean Up SQL Server Plan Cache Bloat
Learn about plan cache bloat and how to identify and clear the plan cache in SQL Server either entirely or plan by plan.
SQL Server Isolation Level Comparison – Repeatable Read and Snapshot Isolation
This article examines the SQL Server isolation level differences between Repeatable Read, Read Committed, and Snapshot isolation.
SQL Plan Cache and Parameterized SQL Queries
In this article, we look at how SQL Server uses the plan cache and how parameterized SQL queries work for generating query plans.
Database Caching Example
This article sheds light on one strategy to implement a database caching system using Python to improve application performance.
Date Range SQL Server Query Performance Issues with Parameter Sniffing
Learn how to get the SQL Server optimizer to use different indexes for a query depending on parameters to improve performance.