I will optimize sql server queries and database performance
Full Stack DotNet Developer, ASPNET Core, WPF and SQL Server
About this Gig
Is your SQL Server database slow? Queries timing out, reports taking minutes, or your app freezing under load? I can fix it.
I am a SQL Server specialist with 9+ years of experience optimizing databases for POS, ERP and web applications that process thousands of transactions every day.
What I can do for you:
- Optimize slow SQL queries and stored procedures
- Index tuning: missing, unused and duplicate indexes
- Execution plan analysis and bottleneck fixing
- Fix deadlocks, blocking and timeout issues
- Database design, normalization and ERD
- Rewrite cursors and loops into set-based T-SQL
- Views, functions, triggers and SQL jobs
- MySQL and SQLite optimization as well
What you get:
- Before and after performance report
- Optimized scripts ready to run
- Clear explanation of every change
- Support after delivery
Please message me before ordering and share your slow queries or database details so I can give you an accurate quote.
Database type:
Centralized database
•
Relational database
Platform:
MS SQL
•
MySQL
•
SQLite
•
SQL Server
Expertise:
Design
•
SQL
•
Performance
•
Query optimization
My Portfolio
FAQ
What do you need from me to start?
Share the slow queries or stored procedures, table structure and, if possible, the execution plan or a database backup. Remote access (AnyDesk/TeamViewer) also works.
Will my data be safe?
Yes. I test all changes on a copy first, never delete data without your approval, and keep your database details fully confidential.
How much faster will my queries be?
It depends on the current design, but slow queries often become many times faster after proper indexing and rewriting. You will get a before and after report with real timings.
Do you work with MySQL or only SQL Server?
My main expertise is Microsoft SQL Server, but I also optimize MySQL and SQLite databases.
