Đã Đóng

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.

Kĩ năng: SQL, Microsoft SQL Server, Lập trình cơ sở dữ liệu, Quản trị cơ sở dữ liệu

Xem nhiều hơn: 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

Về Bên Thuê:
( 11 nhận xét ) Underdale, Australia

ID dự án: #22767974

51 freelancer đang chào giá trung bình $186 cho công việc này

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 Thêm

$150 AUD trong 7 ngày
(37 Nhận xét)
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 Thêm

$100 AUD trong 17 ngày
(25 Nhận xét)
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 Thêm

$400 AUD trong 5 ngày
(7 Nhận xét)
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 Thêm

$220 AUD trong 4 ngày
(13 Nhận xét)
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 Thêm

$240 AUD trong 5 ngày
(20 Nhận xét)
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 Thêm

$250 AUD trong 7 ngày
(10 Nhận xét)
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 Thêm

$175 AUD trong 7 ngày
(6 Nhận xét)
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 Thêm

$170 AUD trong 2 ngày
(16 Nhận xét)
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 trong 5 ngày
(17 Nhận xét)
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 Thêm

$140 AUD trong 7 ngày
(1 Nhận xét)
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 Thêm

$250 AUD trong 1 ngày
(22 Nhận xét)
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 Thêm

$100 AUD trong 1 ngày
(9 Nhận xét)
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 Thêm

$45 AUD trong 2 ngày
(5 Nhận xét)
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 trong 1 ngày
(3 Nhận xét)
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 Thêm

$800 AUD trong 5 ngày
(6 Nhận xét)
3.3
adricabrelles

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

$140 AUD trong 1 ngày
(7 Nhận xét)
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 Thêm

$100 AUD trong 3 ngày
(4 Nhận xét)
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 Thêm

$50 AUD trong 3 ngày
(3 Nhận xét)
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 trong 7 ngày
(4 Nhận xét)
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 Thêm

$200 AUD trong 7 ngày
(1 Nhận xét)
2.2