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.

Kemahiran: SQL, Pelayan Microsoft SQL, Pengaturcaraan Pangkalan Data, Pentadbiran Pangkalan Data

Lihat lagi: 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

Tentang Majikan:
( 11 ulasan ) Underdale, Australia

ID Projek: #22767974

50 pekerja bebas membida secara purata $186 untuk pekerjaan ini


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 Lagi

$150 AUD dalam 7 hari
(38 Ulasan)

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 Lagi

$220 AUD dalam 4 hari
(15 Ulasan)

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 Lagi

$100 AUD dalam 17 hari
(25 Ulasan)

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 Lagi

$400 AUD dalam 5 hari
(7 Ulasan)

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 Lagi

$240 AUD dalam 5 hari
(21 Ulasan)

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 Lagi

$250 AUD dalam 7 hari
(10 Ulasan)

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 Lagi

$170 AUD dalam 2 hari
(19 Ulasan)

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 Lagi

$175 AUD dalam 7 hari
(6 Ulasan)

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 dalam 5 hari
(17 Ulasan)

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 Lagi

$140 AUD dalam 7 hari
(1 Ulasan)

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 Lagi

$250 AUD dalam sehari
(22 Ulasan)

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 Lagi

$100 AUD dalam sehari
(9 Ulasan)

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 dalam sehari
(4 Ulasan)

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

$140 AUD dalam sehari
(9 Ulasan)

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 Lagi

$800 AUD dalam 5 hari
(6 Ulasan)

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 Lagi

$45 AUD dalam 2 hari
(5 Ulasan)

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 Lagi

$100 AUD dalam 3 hari
(4 Ulasan)

I have deep and proven experience in T-SQL development and debugging of queries with huge complexity. My total MSSQL Experience is 10+ years. Five of them was within USA company as Senior SQL/BI Developer. My everyday Lagi

$222 AUD dalam 3 hari
(6 Ulasan)

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 Lagi

$50 AUD dalam 3 hari
(4 Ulasan)

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 dalam 7 hari
(4 Ulasan)