Need someone help me improve the performance of stored procedures

Hi, Please share the stored procedure script. So that we can take things forward. and let me know more about the job.

Hello, As an expert in writing complex sql queries specially for ms sql server, i am very much interested to do this work. Please let me know the more detail about the stored procedure. Looking forward to have a positive response from you. Thanks

Hi I have been working with MSSQL for over 17 years. I am fully experienced as a developer and a DBA. Currently I am working at big financial organization in which I am responsible for the BI department. I have designed and the Developed the Organization’s Reporting Database which has been constructed with SQL Server 2008 R2 Enterprise Edition. The database is being updated daily from the core system with txt or excel files via SSIS or with direct connection at mainframe’s DB2 and a numerous of KPIS are being daily updated during the ETL. For isolation reasons the KPIS are replicated to another DB (with transactional replication) which exploits dashboards via Power BI and reports via SSRS to the consumers. Some KPIS are being replicated with merged (bidirectional) replication. Also, 10 Cubes in SSAS are being daily automatically processed and the end of the ETL. Several other reports are daily automatically produced and sent via email to the recipients. Finally I have designed and developed the bank’s crm DB which is published on the intranet. The DB holds full information about the customers (Customers,Addresses , Financial Data , Contacts , campaigns , etc) and covers 4 countries. To achieve this i have made partitions over the country code. The size of the Reporting DB, is about 4TB and consists of about 4.000 objects and the replicated KPI DB is 350GB. Best Regards mpalgeo

Hi. I'm SENIOR SQL Server DBA from Poland working for London based client so there should be no problem with English communication. I'm also Microsoft MCSA SQL Server 2012 certified so you know who you hire. I specialize in SQL Server maintenance, troubleshooting and performance optizmization. Can you provide that procedure EXECUTION PLAN so that i could check what is the root of the problem ?

Hi, I'm ready to optimize the performance of your stored procedure as I'm expert in optimizing the stored procedure . Please show me your procedure so that I could help you in this regard as I'm the only developer here in freelancer who has passed all sql server exams and you can see this in my profile as well. Please do let me know once you free so that we could discuss this in detail. Thanks

I am sql server dba having more then 10 yrs of experience

Hi, let me know your store procedure details. I like improve performance..but it is not easy. We need to spend time to understand the domain, the query to understand where we can improve. I am senior sql developer and CS teacher. I work for Italy. Have a nice day Angelo

Hi I have sound knowledge of the SQL server have 7 years of experience working on the performance and other Database related activity. i am sure you will be happy to work with us. Please let me know when we can discuss this . i will wait for your response

Please review my profile. I have 7.5 years experience in SQL and 4.8 years experience in SSRS, SSIS. Please let me know more details and when we will start. Sky pe jikenjd

Hello! Performance mostly depends on amount of data and algorithms used to process the data. Unfortunately I wasn't able to identify how much data you have and what type of processing the stored procedure does, however I believe you don't have such complex data that require so much time to be processed, thus I believe I can dramatically improve the performance. Kindly let me know if you are interested.

Dear Sir, I have more than 10 years experience in SQL server database and asp.net development Best Regards, Hassan

Hi, Please share the stored procedure script. So that we can take things forward. and let me know more about the job.

I have almost 4 years of experience in Database Development, Database Optimizations, Database Design and BigData with companies like Soliton Technologies, ZIN Technologies and USAID-DRDF Pakistan My area of expertise are - Database Designing - Database Development - Query Optimization. - Stored Procedures development For complex business - Views, Triggers and Functions development - SQL Scripting - Client Issues Fixations - Creating reports - Index maintenance - BigData - Cassandra

FREELANCER RECOMMENDED ------------------------------------------------------ Can help... I am an Expert... Lets Start! Please start a Discussion with me and we can get started from there... Please check the past projects I have handled and check my reviews for what employers have to say about my work... Can start right now...

I will look into it, in case nothing can be done you will not have to pay me. But I believe a little improvement should be achievable, usually that is the case.

Hello, I am experienced in that kind of projects and I would like to work with you. Please contact me via chat to discuss details. Greetings, Natalie

Hi, I'm a french software engineer, and I worked for 10 years for compagnies, as well as MySQL and SQL Server databases. Now I'm a freelancer. For your project, I am available from now, and for the time you want. Can you provide me the stored procedure for a first quick analyze ? And if possible the database schema ? If you have any questions do not hesitate to contact me. Best Regards.

I do had great experience with process optimization, after the optimization I guarantee that the process takes will run in less than two hours.

I have 10 years working in sql server and i develop application for windows and linux operative systems.

I have 10 yeas using SQL server. At my current job one of my principal activities is improve some posses. Someones before take one hours and after the modification only one minute of two.

I am a highly skilled and experienced PL SQL Developer with wide knowledge of a variety of programs and procedures. Adept at all types of data storage and extraction. Able to work well independently or as part of a team. I am Proficient in Relational Database Management Systems (RDBMS) with other skills like • Expertise in Transact-SQL (DDL, DML, DCL)and in Design and Normalization of the database tables. • Experience in implementing business logic using Triggers, Indexes, Views and Stored procedures. • Extensive Knowledge of advance query concepts (e.g. group by, having clause, union so on). • Experience with tools like SQL Server management studio and SQL Server 2005/2008 integration (SSIS) and reporting services (SSRS). • Proficient in Tuning T-SQL queries to improve the database performance and availability. • Experienced hands in Query tuning and performance tuning. • Experience in monitoring SQL Server Performance using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor. I will look forward to having an engagement, to understand the project better. Thanks a lot. Stephen Mwongela Kamuti