I will fix and optimize sql server queries and stored procedures
SQL Server Optimization and dotNET Developer
About this Gig
Is your SQL Server query slow, returning incorrect results, or difficult to maintain?
I will analyze, fix and optimize SQL Server queries and stored procedures for better performance, accuracy and readability.
I can help with:
Slow SELECT, INSERT, UPDATE and DELETE queries
Stored procedure troubleshooting and optimization
JOIN, GROUP BY, date filter and duplicate issues
Index recommendations
Execution plan analysis
Query refactoring and code cleanup
Validation that the optimized query returns the expected result
You will receive:
Corrected or optimized SQL code
A clear explanation of the changes
Comments or recommendations when needed
Revisions according to the selected package
Please contact me before ordering. Send the query, table structure, SQL Server version, expected result and any error or performance information available.
This Gig does not include complete database redesign, application development or ongoing server administration unless agreed through a custom offer.
Database type:
Relational database
Platform:
MS SQL
•
PostgreSQL
•
SQLite
•
SQL Server
Expertise:
Data structure
•
SQL
•
Performance
•
Query optimization
My Portfolio
FAQ
What information do you need to start?
I need the SQL query or stored procedure, relevant table structures, SQL Server version, expected result and a description of the current error or performance issue.
Do you need access to my database?
Usually no. I can work with SQL scripts, sanitized sample data and execution plans. If database access is necessary, it must be discussed before placing the order.
Can you guarantee a specific performance improvement?
Performance depends on data volume, indexes, hardware, server configuration and application usage. I will explain the improvements found, but I cannot guarantee an exact percentage before reviewing the query.
Do you work with Azure SQL Database?
Yes. I can analyze and optimize queries and stored procedures for SQL Server and Azure SQL Database.
Will you modify my production database?
I normally provide reviewed SQL scripts for testing. Production changes should only be executed after validation and with a current backup.

