SQL Server Query Optimization

Closed Posted 6 years ago Paid on delivery
Closed Paid on delivery

I am working as a DBA and I know sql server administration but only few knowledge in SQL Server Development but not an expert, I need few queries to be tuned one by one, and its a simple query select query uses views and joins which was written by someone I have no time to Query tune.

I will give continuous work if its goes well and also I will share the select query and Execution plan. Before bid please have a look on test select query and exec plan which I had tuned earlier and its performing well. I know sql server very well and How it works, so I will review your suggestion and decide you to select or not.

Please bid only if you are an expert and don't waste our valuable time.

Database Administration Microsoft SQL Server SQL

Project ID: #16163070

About the project

34 proposals Remote project Active 6 years ago

34 freelancers are bidding on average $64 for this job

dotnetsqlCoder

hello I think you could benefit a lot from an indexed view since you have many joins . I havent seen the exec plan but optimizing that sort of queries would require looking the table sizes , indexes , execution pl More

$46 NZD in 1 day
(86 Reviews)
7.2
codetod

Hi I am a database expert with 15 years experience in handling MS SQL databases. I have worked as DBA for large ERP databases and use to write and do performance tuning for SQL queries, procedures and triggers. Quer More

$30 NZD in 2 days
(78 Reviews)
6.4
harishpanoor

A proposal has not yet been provided

$28 NZD in 2 days
(9 Reviews)
5.0
vinaysinghh

I am sql expert certified by Oracle corporation having more then 10 yrs of experience

$56 NZD in 1 day
(52 Reviews)
5.2
sreenivas2903

hi I would like to work on with the query tuning and will let you know . please tell me what do you need

$26 NZD in 1 day
(17 Reviews)
4.3
vw7590795vw

Please message me so I will share your updated script. After that you will compare performance with your query and let me know. Please review my profile. I have 8 years and 2 month experience in SQL Server. Pl More

$29 NZD in 0 days
(22 Reviews)
4.1
dat2na

Greetings, I'm professional database expert with 10+ years experience. Currently I'm working as DBA and DB developer in one of the leader company. As you can see in my profile, I have deep experience of same jobs lik More

$88 NZD in 1 day
(3 Reviews)
4.2
AndreyBarykin

Hello. Have big experience as Senior Database Developer/DBA. Expert in MS SQL. I Know well T-SQL and query optimization. I Checked your query, but didn't find exec plan. And I can't get exec plan without DB access or More

$26 NZD in 2 days
(4 Reviews)
3.2
bnrajumnc

A proposal has not yet been provided

$66 NZD in 3 days
(9 Reviews)
3.7
HadiDar786

hi i will create these sql server queries for you .. i have a great experience in DBMS i will do this job for you .. if yo have any question you can message me . thanks

$20 NZD in 1 day
(4 Reviews)
3.1
sahumk2000

Hi Greetings of the Day, I understood requirement, I am interested in this task, I am full time freelancer carrying 13 yrs of experience in Mobile development, Web and Windows development using ASP.Net, MVC, C#, WP More

$31 NZD in 1 day
(4 Reviews)
2.1
katiewells3

I am an Australian technical Business Analyst with a decade's experience in SQL server programming. I have reviewed your query and can see some quick improvement wins (e.g. you can change your UNION statements to UNION More

$29 NZD in 1 day
(3 Reviews)
1.7
lemarin68

Dear friend, we need the execution plan for this query, you did not include objects, or data to see where it could be improved,it is very difficult only with what you have attached, please post your .sqplan file, to g More

$24 NZD in 1 day
(2 Reviews)
1.2
bala07121988

I have experience in Database programming language. I have experience in Oracle, SQL server, DB2 and also having experience performance engineer.

$33 NZD in 3 days
(1 Review)
0.8
orIMkD

If you don't have often insert update into this table, that it will be nice to add indexes. for table MNHHS_custom_ERF_ReceivedMessageView (receivedMessageId, isOpen index) for ERF_ReferralRequestView (receivedMessa More

$26 NZD in 1 day
(0 Reviews)
0.0
micmicmic0094

provide best quality of work. and i will provide the work how you want it to be executed Honest, Integrity and Time

$28 NZD in 1 day
(0 Reviews)
0.0
MoOnstrinhOo

Dear Sir, As you can read on my profile I'm a IT Consultant with more than 2 years of experience. My main interested isn’t money, at this time my main focus is improving my Freelancer profile, so I'm willing to More

$17 NZD in 1 day
(1 Review)
0.0
niting3

I have been working as a SQL Server developer since last 6 years. I had a look at your queries. To optimize it, I'll have to see existing indexes on tables being used and then can tell you where/if you need indexing to More

$36 NZD in 1 day
(0 Reviews)
0.0
sarathiraj

Hi.. This is vijay from India. Would like to assist you to tune the query. I am working as subject matter expert and having 10years of experience as sql dba. Let me know for further discussion. Relevant Skills and Exp More

$56 NZD in 2 days
(0 Reviews)
0.0
jlrterceiro

I work with query tunning in sql server, postgresql and mysql, I think I can help you. But the query plan is missing.

$26 NZD in 1 day
(0 Reviews)
0.0