You will get expert level consulting on Microsoft SQL query optimisation
You will get expert level consulting on Microsoft SQL query optimisation
Project details
Within this project, you will get a solution for the following tasks:
- query performance analysis
- if possible, optimized (rewritten) version of your query
- recommendations on how you can change the database structure, in case this is the reason for the bad performance
- recommendations (and script) on index creation/change
- query performance analysis
- if possible, optimized (rewritten) version of your query
- recommendations on how you can change the database structure, in case this is the reason for the bad performance
- recommendations (and script) on index creation/change
Database Type
MS SQLWhat's included
| Service Tiers |
Starter
$100
|
Standard
$200
|
Advanced
$400
|
|---|---|---|---|
| Delivery Time | 1 day | 3 days | 5 days |
Number of Revisions | 3 | 3 | 3 |
Number of Queries | 2 | 5 | 10 |
Query Debugging | - | - | - |
Query Optimization | |||
Query Scheduling | - | - | - |
Query Analysis | - | - | - |
Source Code | - | - | - |
Optional add-ons
You can add these on the next page.
Fast Delivery
+$100
Additional Revision
+$25
Additional Query
+$45
Query Debugging
(+ 1 Day)
+$100Frequently asked questions
44 reviews
(42)
(2)
(0)
(0)
(0)
This project doesn't have any reviews.
AB
Adam B.
May 22, 2025
🚀 SQL Server Performance Tuning Expert (Azure SQL, Freight Optimization Procedure)
Excellent work by Michael in helping us tune a complex stored procedure for our business. Would gladly work with him again.
AA
Alexandra A.
Apr 29, 2025
Database systems
AR
Adam R.
Mar 17, 2025
Postgres Optimization
AA
Alexandra A.
Mar 6, 2025
ER models, relational models, SQL, databases
good
ES
Eduan S.
Sep 25, 2024
SQL Server developer needed for database and stored procedure support and maintenance
About Michael
SQL Server, query optimization, BI, Power BI, SSAS, TSQL, ETL
100%
Job Success
Batumi, Georgia - 9:33 pm local time
• Strong hands-on experience using Microsoft SQL Server databases and related tools.
• Cloud (Azure or AWS) and on-prem environment
• Experience in Extraction, Transformation and Load (ETL) strategy, design, and implementation.
• Experience in DWH and Reporting systems development and maintenance
• Design and implementation of normalized data structures, de-normalized structures, and dimensional structures
• Business logic development in SQL language
• SQL stored procedures and functions
• Design, build and maintain SQL scripts and complex queries for data processing
• Management and implementation of database models, data flow diagrams, database schemas, DB scripts and DTD schemas
• Database performance tuning and SQL query optimization
• Experience in design, build and deployment effective SSIS packages.
• Using SSIS to move, load, and transform data.
• Experience with logging and error handling in SSIS Packages.
• Building/publishing/sharing dashboards/reports in SSRS and Power BI
Technical Skills
• Databases: MS SQL Server, PostgreSQL, Google Spanner, Google BigQuery, MySQL, Oracle
• Microsoft BI Tools: Analysis Services (SSAS), Reporting Services (SSRS), Integration Services (SSIS), Power BI
• BI/Reporting Tools: Oracle-Hyperion BI, SAP BI, Oracle BI, DOMO
• Programming languages: SQL (TSQL, PLPGSQL, etc.), MDX, Python, R, C, C++, Pascal (Turbo Pascal, Object Pascal)
• Modeling: IDEF0, IDEF1, IDEF1X, IDEF3, DFD, UML (BpWin/ErWin, Rational Rose).
Steps for completing your project
After purchasing the project, send requirements so Michael can start the project.
Delivery time starts when Michael receives requirements from you.
Michael works on your project following the steps below.
Revisions may occur after the delivery date.
Client purchases the project and describes the problem
Client purchases the project and describes the problem
Client provides access to DB
Client provides access to DB or a copy of the data which allows to reproduce real data distribution