Closed

MS DB Query/SP Optimization

I have got a ms SQL relation database. There is one complex search query with around 30 joins and self joins. It has around 21 where clauses. I am looking for ways to speed up this query. You can add more index to database or restructure this query.

I will provide you with copy of database.

I can see the query only has a where clause filtering on a name (company name I think). Leaving the search fairly open ended like this can sometimes cause longer response times, compared to filtering by a specific client, sample number, job, date range etc. Also this is a free text field (which requires a number of joins) which probably contributes to the longer time.

Skills: SQL, Microsoft SQL Server, Database Programming, Database Administration

See more: part time jobs software development company sri lanka, convert ms sql query mysql, copy paste photoshop picture ms publisher, copy paste vba macro ms word, db query config, ms access query creator, wordpress db query, community development time doctrinaire open ended flexible accommodating, copy typing books to ms word, db query, sp optimization sql server 2008 free lancer, i need a part time worker for my company, logo like golden gear company, part time project web design company in kolkata, we are looking for a marketing pr person more focus on pr full time wanted for small company located in queens we are looking fo, CAPTCHA TYPING,copy paste,copy typing,error checking,ms word, copy paste,copy typing,error checking,ms word,data entry

About the Employer:
( 11 reviews ) Underdale, Australia

Project ID: #22767974

51 freelancers are bidding on average $186 for this job

Neno585

Hi, sounds to me like lack of covering index that would reduce number of reads inside the database. It is usually the case when there is numerous Joins+WHERE conditions. However, if you are able to share backup, I coul More

$150 AUD in 7 days
(37 Reviews)
7.5
fanninson45

INTRODUCTION I am an experienced Professional with Database Programming and Administration skills across MySQL, MS SQL and Business Intelligence Development. I have 4+ years’ experience with Database Programming and More

$100 AUD in 17 days
(25 Reviews)
6.0
dhanuitdevendra

Hello, Hope you are doing well! We can help you with our Database Developer as a Service (DEVaaS). Please visit [login to view URL] for details. Please have More

$400 AUD in 5 days
(7 Reviews)
5.4
schoudhary1553

Hello Sir, I am expert who understands the value of time. I pride myself in my attention to detail. I am very hard working and aim to deliver in less time than quoted. I want to make you, my employer happy without cha More

$220 AUD in 4 days
(13 Reviews)
5.6
SergioAlfaroV

Hello! I am a Computer Engineer, MCSA SQL Server, MS Certified Database Solutions Expert, with 14 years of experience as a Database Engineer and SQL Developer. I am a near-native English speaker, currently available an More

$240 AUD in 5 days
(20 Reviews)
5.6
IMExpertEngineer

Hi, I'm sql server expert and have done many query optimization and I can easily do this job. Could you please share which version of mssql server you are using ? Also, what's the size of databae ? I can start work More

$250 AUD in 7 days
(10 Reviews)
5.0
adeelpirzada

Hello, I am a Full Stack Lead Developer with a Decade of Experience with strong Expertise in Nodejs , ReactJs and Angular using Mysql or MongoDB. I have comprehensively developed social media, shopping carts, p More

$175 AUD in 7 days
(6 Reviews)
4.9
jayantavkumar

Proposal - You can expect any kind of work on SQL Server with performance tuning. Let me know if you want to discuss further. I am a database / Business Intelligence / solution architect. I have more than 14 years of More

$170 AUD in 2 days
(16 Reviews)
4.6
sreenivas2903

Hi i am expertise in sql queries and also query runing if u are interested please let me know do that we will fix

$277 AUD in 5 days
(17 Reviews)
4.3
Toa7

Hello. I have extensive experience with Database Administration, Database Programming, Microsoft SQL Server, SQL which are the skills required to get this job done. I am a full stack developer with 8 years of experienc More

$140 AUD in 7 days
(1 Review)
4.0
vw7590795vw

Please review my profile. https://www.freelancer.com/u/vw7590795vw.html I have 10.1 years experience in MS SQL Server and 7.4 years experience in SSRS, SSIS (Import / Export). Please let me know more details and when More

$250 AUD in 1 day
(22 Reviews)
4.1
harihut

Hi Sir, I am core SQL Server DBA with 10+years of experience . I have done many performance tuning projects of SQL Server in my career .I am proficient in SQL Server Administration and Development . I can optimize y More

$100 AUD in 1 day
(9 Reviews)
3.7
sqlnr

I’m an acknowledged expert in sql server. Ex Microsoft MVP. See my web site www.nigelrivett.net. Would need to know how the query works, can it be put in a stored procedure or split into multiple queries. Which version More

$45 AUD in 2 days
(5 Reviews)
3.7
TEKSCENT

Hi i have around 10 years of experience in SQL developement and maintain and working as team [login to view URL] me know how can i help you

$277 AUD in 1 day
(3 Reviews)
3.4
huseyinaygun

Dear Sir/Madam, I have relational database design and development experience of 10 years. Several months ago I worked on the performance issue of an HR database where the query included searching a large free-text f More

$800 AUD in 5 days
(6 Reviews)
3.3
adricabrelles

Hi I am a Senior DBA with more than 15 years experience. I can help you. Regards.

$140 AUD in 1 day
(7 Reviews)
3.4
WeazenSoft

Dear Prospect Hiring Manager, After a full understanding of your project description, I can say I could help you with strong interests and desire. I am a serious bidder here and i have already worked on a similar p More

$100 AUD in 3 days
(4 Reviews)
2.7
Shakerfawzy

Hi,I can help you I'm Database Administrator with 10+ years of experience in maintenance, security, backup, recovery, designing, coding, testing and supporting solutions in SQL Server environments. Proficient in an ass More

$50 AUD in 3 days
(3 Reviews)
2.7
NoSonforhim

I have 20 years in Database Developing, administration, Programming, System Analysis, Data Analysis using Ms. Access, Ms. Excel, VBA, VB6, Vb.net, C#, SQL, SQL/PL SQL, and MS SQL Server

$140 AUD in 7 days
(4 Reviews)
2.4
L8G8S

Hi! Pretty interested by your project, but I am quite sure you won't read my message with this many proposals you got. Anyway. I have read few explanations in these proposals and most of the time it makes sense : a b More

$200 AUD in 7 days
(1 Review)
2.2