I will optimize slow sql server queries and stored procedures
About this Gig
Are you dealing with a slow SQL Server query or stored procedure? I will analyze your T-SQL code, identify performance bottlenecks, and suggest practical ways to improve performance.
I can help with slow queries, stored procedures, execution plans, indexes, joins, filters, scans, sorts, and inefficient T-SQL.
This Gig includes analysis of one SQL Server query or stored procedure, T-SQL code review, execution plan review when available, index suggestions, optimized T-SQL when applicable, and a clear explanation of my findings.
Please provide your T-SQL code, SQL Server version, details about the performance problem, and an execution plan if available.
Please contact me before ordering for multiple queries, multiple stored procedures, or a full database performance review.
Do not send passwords, credentials, or sensitive information.
FAQ
What information do you need to optimize my query or stored procedure?
Please provide the T-SQL query or stored procedure, your SQL Server version, a description of the performance problem, and the actual execution plan if available. Relevant error messages or screenshots can also be helpful.
Do you need access to my SQL Server?
Not always. I can often analyze the issue using the T-SQL code, execution plan, table/index information, and relevant diagnostic results. If additional information is needed, I will let you know.
Can you guarantee that my query will run faster?
I will analyze the query and provide optimization recommendations where applicable. Performance can also depend on database design, data volume, indexes, server resources, blocking, and workload, so a specific performance improvement cannot be guaranteed.
Can I send you multiple queries or stored procedures?
The Basic package covers one query or one stored procedure. Please contact me before ordering if you need optimization of multiple queries or procedures so we can determine the appropriate scope.

