Improve speed of Stored Procedure

I have the script ready please let me know once you are online. I'm really very interested to work with you as you are giving challenging task to the developers :)

Hello, I am IT engineer with European diploma since 2005 Certified as Technical specialist in Microsoft SQL Server BI , i have more than 8 years in IT projects with 5 years working around databases and SQL development around (SQL Server ,Mysql ,Oracle ) . My last job was database consultant within Accenture ,for more than 4 years .I worked for several database projects and advanced SQL development on behalf of European Customers (Carrefour, LOREAL,Eurovia ..). I have strong skills in database development and SQL Tuning such as your needs,and given my experience, I think I am persuaded to give you High quality of work delivery withing budget and time Best regards,

Hi, I did a check for your procedure script. Contains a lot of joins. Now indexing can be only applied on underlying tables. Can you send me the script for tables involved? Thanks, Amit

Hello The problem with your sp do not reside in it directly, if some of the fields in the tables (views or table functions) are from UDF there you have the main culprit from it running slow., you will have to extend the sp by calculating those values in it without using the UDF's. (without using cursors) If all the data you are inserting comes directly from tables then you need to optimize them by creating the right indexes for those tables. use the query analizer to help you create the needed indexes (copy sp code, in a query window, declare the parameters as var and give them the right value) I hope these guidelines help you solve your problem. Reynaldo.

How can I send you my proposed solution for test? I've wrote an updated version of the procedure, but I cannot test it because I don't have tables' structure. Please, give me an e-mail address or another way to communicate. Best regards, Georgi Nikolov

1. Having 8 Plus years of Experience in SQL Database Administration. 2. Played offshore DBA support roles in onsite-offshore model projects 3. Experience in performing regular Backups, troubleshooting the failed backups and Restoration of databases. 4. Experience on Table Partitioning, Database Purging and Performance Optimization Projects. 5. Recovery of the database during crash or data Loss. 6. Experience on DTS, SQL Jobs Creation, Scheduling 7. Proven abilities to troubleshoot, maintenance and database administration 8. Knowledge on Log shipping, Replication and Database Mirroring, 9. Ensuring data consistency in the database through DBCC commands 10. Strong skills of T-SQL. 11. Having hands-on Knowledge on MS-BI tools (SSIS) 12. Knowledge of SQL Profiler, 13. Knowledge of Resource Governor, Data Collector in SQL 2008 14. Having hands-on Knowledge on MS SQL 2012 New Features

Have 5 years of experience in MS SQL and SQL development. Current role involves working with SQL 2005 with SQL store produce that provide data for reports. Also Oracle 9i certified in PL/SQL OCA

Since your data is large major improvement can be done by creating table partitions based on the year. By default SQL server creates a single file for storing data due to which performance reduces as the data size increases. By creating partitions we can split entire data into number of files which significantly reduces disk read time. Also you must evaluate your query in query analyzer and check which operation of the query is becoming the bottleneck and then try to remove that bottleneck. It would be great if you could attach that analyzer report. I can help you out in taking out query analyzer repot. Guneet Kalra Microsoft Certified BI Expert

I am Microsoft Certified SQL Developer with 5+ years experience. I will take care of you performance needs as quickly and accurately as possible. I can also send you minor changes to your query to help increase your performance. How would you like me to send this change to you? Thanks, Sam McManus