Browse categories
Explore
Fiverr Pro
English
$
USD
I will optimize slow sql server queries, stored procedures and database performance
About this Gig
Slow reports, timeouts or pages that take forever to load? The problem is often a few badly performing SQL queries. I will find them, fix them and make your SQL Server database fast again.
I have 5+ years of writing and tuning T-SQL queries and stored procedures for enterprise, banking and reporting systems.
What I do:
- Diagnose slow queries using execution plans and query statistics
- Rewrite queries and stored procedures for speed and readability
- Recommend and create the right indexes
- Fix deadlocks, parameter sniffing and blocking issues
- Write new stored procedures, views and functions for your app or reports
You get:
- Optimized, commented SQL scripts ready to run
- Before and after timings so you can see the improvement
- A short written summary of what changed and why
Message me with your query and table details before ordering so I can recommend the right package.
Database type:
Relational database
Platform:
MS SQL
•
Oracle
•
SQL Server
Expertise:
SQL
•
DML
•
Performance
•
Query optimization
My Portfolio
FAQ
Do you need access to my production database?
No. The query, table schema and the actual execution plan are usually enough. A copy or test database with realistic data volume gives the best results.
Do you work with databases other than SQL Server?
SQL Server and Azure SQL are my main focus. I also have experience with Oracle (jobs, schedulers and cross database integration). Message me to check your case.
