Optimizing SQL Server Script

Hi I have taken a look at the script you attached, its a bit long, and cant understand it completely without running the script within the database. How many rows do you have in tables dtaprojectinfo, and lovWorkflowDefinition and in view vwIPDProjectInfo? Will you be able to send me some sample data in excel to try this out, or will I be able to connect to your on team viewer or RDC and try this out? Thanks Roni

Hello Sir /Ms, Please talk to the chat for details About me I am a web developer focused on Microsoft technologies, I worked about 4 years developing web applications built using Asp.net and SQL Server 2005, 2008 and 2012.

Hi , Can you please share table script and some dummy data and desired output you want from that. That will help me understanding the query and will provide you better solution. About me , Well I am having 6+ years of experience in Web Development. I have worked on below technologies/languages/database server. - Asp.net,C#.net,Asp.net MVC - Linq to SQL,Entity Framework - Javascript,Jquery,KnockoutJS,AngularJS - Crystal Reports,DevExpress Reports - SQL server,SSIS Package,SSRS Reports - Facebook Graph API - Application Security Remediation - SVN,TFS I love working on SQL and query/sp optimization . I can achieve the results that you are asking for. We can discuss further on chat(Skype:mahajan344). Looking forward from your end. Thanks Nikhil Mahajan

A proposal has not yet been provided

Hello Sir I have built this type of complex queries in my sp. if u interested then chat with me. Thank you

Your database , your database administrator, your database designer and you query are a whole DISASTER!!! it is impossible to understand and impossible to repair, Please DO NOT TOUCH. If it is working slow, it is better than NOT WORKING. It is my honest suggest to you. Not waste money in freelancers. NOBODY can do it,

Good morning, to resolve this will take some time because there are a number of issues. You will need to be able to reboot the server for some of the fixes I propose to take effect since they only occur on reboot. I will need RDP access into the server as an administrator and be a member of the SQL Server sa role. I don't know if this work will all take one day or a week --it depends on what I find when I look at the server. *That is a monster join --I can't speak for whether getting it to run in one second is possible without looking at the server.

Hi, I am currently working as a software developer. In my company I have optimized very complex SQL scripts performance. I can do this for you.

Hi - There is a lot of room for improvement in this query. You have some nested testing that can be replaced with a cleaner approach. You haven't said what version of sql this is. I'm a MCSE Data Platform, I've been certified in sql server since version 7.0 and do this kind of thing all the time. I'm willing to work for a low rate just to get a successful project listed on this site. Once I have some test data I can turn this around in less than 2 days.

Depending on how many records of the using tables, and how the relationship keys or indexes or table structure

Hi, I've poured over the query for 90 minutes, I know exactly what I want to do, and I started to type up the changes. There is room for a lot of performance improvement and I'm fully confident I can pull it off as well as anyone else. I was a DBA working on things like these for 3 years and I've currently been working on my own SQL Server based project for the past couple months straight. I think I can finish this in a half day pretty easily but I've set it as 2 days because I'll possibly need some feedback/testing from you and just to be on the safe side. I have no projects but my own, so this will have my sole focus. If the bid is still open when I get up, I'll get back to working on it with the goal of having a couple refined versions for you to try as soon as you would reward me the job. The reason I'm so eager is that it has been extremely difficult to win any bids here without any reputation. Unless you are in a super rush, you really have nothing to lose from trying me out! If you have any questions at all please let me know. Cheers, Dorlan

I have expierence in MYSQL as as MSSQL i have worked for many big Companies, delt with creating new queries to performance and bottleneck issues.

Hello, As mentioned in my profile I am in IT professional with over 15 years of experience in Database design & Administration as well as programming in SQL and other languages. The SQL programming is my top skills with over 12 years of experience in various SQL flavors including Mircosoft TSQL, Oracle PSQL and Informix ISQL. If you award this contract I am fully confident that I will be able to provide you with the best outcome in optimizing your SQL query. Thank You. wollabiesonline

I have 5 year exp in SQL server

I have over 20 yrs experience with sql. sure I can help you.

A proposal has not yet been provided

The slowness most probably comes from the multiple references to the tables aliased "work" and "proj". Could you please provide the creation scripts for these tables also? It would be easier to debug if I had the actual tables to test against. You can send them via private message. Please consider my bid for this task, I will have the query fixed for you in two days. Thank you!

 Well versed in OOPs and RDBMS concepts & design.  Strong knowledge of SQL server 2005 and 2008 , SSIS  Experienced in designing reports using SQL Server Reporting Services (SSRS)  Skills in IBM BI tool Cognos  Strong Knowledge in Insurance and Telecom domain  Team Handling skills  Ability to exercise control the executed tasks with the planned activities  Strong analytical and problem solving abilities.  Quick learner and excellent Team Player having profound insight to determine priorities, schedule work.  Strong C# and .Net programming.  Skills to understand the business requirement and convert it to an analytical plan  Excellent Presentation skills.  Superior verbal and written communication skills, client handling experience please let me kinow where you are wexecuting this report..which tool u r using for the same..

Past Works: Domain: Oil & Gas : Fortune 10 company, A very complex project to create a integrated view of different other systems. Architected the Integrated view system (Data Modelling, ETL packages design) Sources were majorly Oracle & SQL Servers. Domain: Electricity(Country : Belgium). A data migration project . Data tables with billions of rows. Exceptionally high performance ETL packages designed using SSIS. Technology used: SSIS, MS SQL Server, Oracle. Domain: Mortgage Banking . A data migration project. Technology used: SSIS, MS SQL Server, MS Excel, MS Access. Domain: Retail. Development of ETL packages and reporting, Architect the data feeds. Incorporated template based ETL (data feed) development. Technologies used: SSIS (ETL), SQL server, Oracle Domain: Retail. Data Migration and ETL re-design. There were several systems, Databases presents. Developed and designed SSIS ETL packages to make data in sync among these systems. Technologies used: SSIS (ETL), SQL server, SSRS, Netezza Domain: Insurance, (Client Benefit Management System)Data Migration & ETL Development. Client redesigned the CBMS system. Technologies used: SSIS (ETL), SQL server, Oracle. Domain: Insurance, Legacy System Data Migration. Legacy system (MS Access based 180 databases and related applications) conversion (data migration) into Oracle 10g based centralized system. Involved in data modeling of centralized Oracle DB. Technologies used: SSIS (ETL), MS Access (Forms, Reports), Oracle

A proposal has not yet been provided