Mehdi Ghapanvari

Mehdi Ghapanvari is an SQL Server database administrator with 6+ years of experience. His main area of expertise is improving database performance. He is skilled at managing high-performance servers that can handle several terabytes of data and hundreds of queries per second, ensuring their availability and reliability. To enhance the performance of the database, he has implemented various performance-tuning techniques, including query optimization and index tuning. He has also developed backup and recovery strategies to protect critical data in case of disasters. Mehdi currently manages the SQL Server databases for a large organization.  Mehdi is actively seeking new opportunities to apply his expertise and contribute to impactful projects. You can reach him at SQLDBA.Mehdi@Gmail.com.
  • MSSQLTips Awards: Rookie of the Year - 2023
Title Category Date
SQL Server Memory Optimized Table vs. Temporary Table Performance Performance Tuning2026-06-08
Manually Update Statistics in SQL Server Database Administration2026-05-27
Understanding Query Performance Issues Caused by Local Variables in SQL Server Performance Tuning2026-05-17
Don’t rely solely on SQL Server’s missing index recommendations Indexing2026-05-14
SQL Query Troubleshooting: Memory Issues and Timeouts Performance Tuning2026-05-13
SQL Bulk Insert with TABLOCK Performance Considerations Locking and Blocking2026-05-09
SQL Server Table-Valued Parameter Join Issues in Stored Procedures Performance Tuning2026-04-04
Memory Grant Feedback Reduces the Impact of Outdated SQL Server Statistics Performance Tuning2026-03-14
SQL Server Table Valued Function Performance Comparison – Multi-Statement vs Inline Performance Tuning2026-03-08
Optimize SQL Server Query without Changing the Query Performance Tuning2026-03-06
SQL Server Concurrency Issues with Parallel Query Plans Performance Tuning2026-03-02
SQL Server Table Partitioning and Query Performance Partitioning2025-12-08
SQL Parameter Sniffing Fix with a Covering Index Performance Tuning2025-11-03
SQL Query Memory Consumption in SQL Server 2025 Performance Tuning2025-09-30
Query Performance Degraded After SQL Server Upgrade Performance Tuning2025-07-29
SQL Server 2025 OPPO and PSPO SQL Server 20252025-06-19
SQL Plan Cache and Parameterized SQL Queries Performance Tuning2025-05-29
SQL Temp Table vs Table Variable Join and Performance Issues Temp Tables2025-04-26
Date Range SQL Server Query Performance Issues with Parameter Sniffing Performance Tuning2025-03-20
Improve Query Performance when SQL Server Ignores Nonclustered Index Performance Tuning2025-02-03
SQL Server Performance for Natively Compiled SQL Stored Procedures Performance Tuning2023-10-09
Parameter Sniffing with Temporary Tables in SQL Server 2022 SQL Server 20222023-09-20
SQL Performance Degraded after Rebuilding Clustered Columnstore Index Indexing2023-09-12
Correct SQL Server Parameter Sniffing when using TOP Clause Performance Tuning2023-08-22
Improve SQL Server Query Performance for Clustered Index Seek Indexing2023-08-16
Improve SQL Query Performance when Estimated Rows is Incorrect Performance Tuning2023-07-17