I will review and optimize one slow sql server query
Senior Backend Engineer for API Debugging and SQL
About this Gig
Is one SQL Server query or stored procedure slow, timing out, or reading more data than expected?
I review the SQL, actual execution plan, schema, indexes, and representative parameters to identify the cause.
This package covers one SELECT query or one query inside a stored procedure. Delivery includes findings, focused SQL or index recommendations, a revised query where applicable, and verification notes. With a reproducible test environment, I compare results and logical reads before and after.
I bring 14+ years of backend and integration experience, including enterprise financial systems. Please contact me before ordering to confirm the scope and available evidence.
The gallery shows an independent AI-assisted demo on 500,000 synthetic orders. Logical reads fell from 1,556 to 9 with matching results. Production gains depend on your workload and data.
Share sanitized SQL, an actual plan, relevant table and index definitions, SQL Server version, and sample parameters. Use test data and a development environment.
Database type:
Relational database
Platform:
SQL Server
Expertise:
SQL
•
Performance
•
Query optimization
FAQ
Is a specific speed improvement guaranteed?
The improvement depends on the query, data, indexes, and workload. I provide findings and recommendations, and measure changes when a reproducible environment is available.
Does this package cover an entire database?
It covers one SELECT statement or one statement inside a stored procedure. Multiple queries, server-wide tuning, or complex locking investigations need a separate scope.
What will I receive?
A concise diagnosis, SQL or index recommendations, a revised query where applicable, and verification notes. Before and after measurements are included when the supplied environment supports them.

