You will get expert level consulting on Microsoft SQL query optimisation

Michael B.
Michael B. Michael B.
5.0
Top Rated

Let a pro handle the details

Buy Database Queries services from Michael, priced and ready to go.

You will get expert level consulting on Microsoft SQL query optimisation

Michael B.
Michael B. Michael B.
5.0
Top Rated

Select service tier

  • Delivery Time 1 day
  • Number of Revisions 3
  • Number of Queries 2
    • Query Optimization

1 day delivery — Apr 22, 2024
Revisions may occur after this date.
Upwork Payment Protection
Fund the project upfront. Michael gets paid once you are satisfied with the work.

Let a pro handle the details

Buy Database Queries services from Michael, priced and ready to go.

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
Database Type
MS SQL
What's included
Service Tiers Starter
$100
Standard
$200
Advanced
$400
Delivery Time 1 day 3 days 5 days
Number of Revisions
333
Number of Queries
2510
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)
+$100

Frequently asked questions

5.0
38 reviews
97% Complete
3% Complete
1% Complete
(0)
1% Complete
(0)
1% Complete
(0)
Rating breakdown
Availability
4.9
Deadlines
4.9
Skills
5.0
Quality
5.0
Cooperation
5.0
Communication
5.0

OS

Owen S.
5.00
Nov 1, 2023
60 minute consultation I recently consulted with Michael and was thoroughly impressed. Michael provided practical advice and demonstrated a genuine commitment to problem solving. I wouldn't hesitate to recommend him for any well-suited project and will seek his expertise again. Thank you Michael!

BJ

Brandon J.
5.00
Jan 5, 2023
Convert function written in MS Access to work in MS SQL Server Michael delivered great work with great responsiveness and work was completed quickly. Everything I could have asked for!

PS

Phil S.
5.00
Dec 12, 2022
PostgreSQL recursive query

GY

Greg Y.
5.00
Jul 22, 2022
SQL Server 2017: Troubleshoot and fix slow performing query

KL

Kurt L.
5.00
Jul 19, 2022
1. On original trigger, make it work if multiple records upated. 2. Brand New Stored Proc Accurate.
Great solutions. Not just the easy solution. But, efficient solutions.
Timely.
Easy to work with.
Understands the need very quickly.
Michael B.

About Michael

Michael B.
Microsoft SQL Server, BI, SSIS, SSRS, Power BI, SSAS, TSQL, ETL
100% Job Success
5.0  (38 reviews)
Batumi, Georgia - 7:46 pm local time
• Database developer and architect with over 10 years of experience. Able to deliver data management vision, goals, priorities, design principles, and operating policies in support of the business goals of the organization.
• 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

Review the work, release payment, and leave feedback to Michael.