Phoenix - Your AI AssistantSQL Server Query Optimisation — Up to 5 Slow Queries Tuned
Delivery in
4 days
- Views 7
Amount of days required to complete work for this Offer as set by the freelancer.
Rating of the Offer as calculated from other buyers' reviews.
Average time for the freelancer to first reply on the workstream after purchase or contact on this Offer.
What you get with this Offer
I will analyse and optimise up to 5 slow T-SQL queries — reading execution plans, identifying table scans from missing indexes, parameter sniffing issues, implicit conversion blocking index seeks, excessive key lookups, and suboptimal join strategies — and delivering rewritten, optimised queries with supporting index recommendations and before/after execution plan comparison. SQL Server query performance problems are diagnosable and fixable when execution plans are read correctly; the majority of slow queries trace back to one of a small number of root causes that an experienced SQL Server developer can identify and resolve systematically.
For each query I provide an execution plan analysis, root cause identification, the optimised T-SQL with inline comments, supporting index DDL (CREATE INDEX or covering index), and a before/after elapsed time and logical read count comparison confirming the improvement.
Designed for development teams, DBA teams, and businesses with SQL Server applications experiencing specific slow query performance affecting application response times or report generation.
For each query I provide an execution plan analysis, root cause identification, the optimised T-SQL with inline comments, supporting index DDL (CREATE INDEX or covering index), and a before/after elapsed time and logical read count comparison confirming the improvement.
Designed for development teams, DBA teams, and businesses with SQL Server applications experiencing specific slow query performance affecting application response times or report generation.
What the Freelancer needs to start the work
Please share the slow T-SQL queries (or their Query Store query IDs), the relevant table DDL and existing index definitions, current execution plans if available (SSMS or XML), your SQL Server version, and the current and target query execution times.