MSSQL SERVER OPTIMIZE STORED PROCEDURES PERFORMANCE

Hello, As an expert in MSSQL and optimizing stored procedure, i am very much interested to work on this project. Is it allowed to do any changes in the related tables like adding indexes? Let's discuss more in detail. Thanks

Hi, I am Nallakumar. I have more than 12 years of experience in MS SQL SPs, Indexing etc. I can make the SPs optimised without compromising existing logic. Slowness may related to the loops, conditional statements or even based on indexes. I need to look at the SPs to troubleshoot and find the best possible way. I am ready for a discussion and take it from there. Thanks, Nalla

As per my understanding, MSSQL stored procedures are to be optimized to gain better execution time. Kindly let us know the detail of a sample stored procedure so that we may know the complexity of the optimization? Look forward to hearing from you. Thank you, LEADconcept

Hi, I can help you by refactoring T-SQL in stored procedures. I would like to talk to you by chat Experience to apply: Microsoft platform: Language: VB.NET / C # ASP.net / Web Form - / MVC MySql Server / SQL Server About me I am a web developer focused on Microsoft technologies, I worked about 4 years developing web applications created with Asp.net and SQL Server 2005, 2008 and 2012 Post comments Record Saved Community

Hi! I offer you my skills for your task. I have long term (12+ years) for working with MS SQL SERVER (starting frrom MS SQL SERVER 2000) as admin and as developer for T-SQL (stored procedures, triggers, user functions, tasks). I can check performance and refactoring your SP. Basically i think that your problem can be resolved by changing/optimizing SQL query (optimizing cursors fetching and etc). So, I'm ready to start. From you i need access to your SQL SERVER. Of course - i will work with copy of your database, not with real.

Hi There, You have a massive DB with 500 SP. I'm sure you knwo teh common problems associated with SP performance to look for 1) Reindexing of tables. 2) Create views in case there are more joins 3) Use No Lock I believe in building long relationships, trust and good communication. I usually reply within minutes of ping from you. I'll wait for your ping on chat to discuss more on the project. I have more than 10 years of experience in developing .NET solutions with building small and big distributed high-load applications. I am a technologist at heart with the right intent and skillset to deliver high-quality and stable projects in web application and hybrid mobile application using new technologies. Regards, Shobhit Pundir

Hello, I have been working as a consultant for 6 years now, primarily their database migration from Oracle to SQL server. I have experience of optimization as well as maintenance. How about, you give me 1 stored procedure task and also tell me database schema, and access and documentation if possible and i will do it for you to make you feel comfortable in my abilities? I can also give you link of my LinkedIn profile and you can see recommendations. Thank you and Look forward working with you.

Hi, My name is Benjamin. I'm an expert solution architect and developer with over 14 years of experience. As a Microsoft certified expert, I have helped many enterprises optimize their SQL procedures.. I can ensure high quality work. Look forward to a chat. Thanks,

Hi, My Name is Ali and I can work on it with immediate availability. I am expert in Optimization of queries, Stored Procedures and Functions with 11 years of experience. See my portfolio for reference. Let's have quick discussion so I can work on it.

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 duties were: development of different types of reports, dashboards, KPIs, ETLs and functional modules for application`s data layer, Investigation and resolution of performance and locking issues on high loaded production environment. You could accept me and i will share my expertise with you.

Hi, I'm exper sql server DBA and been working in sql server since 2005 and I've done lot of stored procedure optimization in past. I can work on this project and fix your issues. Could you tell me what's the size of database ? and it's OLTP DB or OLAP ? I'll be waiting for your response on this. Thanks

Hi, I have worked as a database administrator for 5 years. Responsible for tasks of optimization of stored procedures, optimization of disk space used by tables, maintenance of log file. I worked with SQL Profile and analysis of the Execution Plan of the SQL Sentences

I am a microsoft certified BI developer with 10 + years of experience of working with ETL and BI tools such as SSIS , SSAS , Azure ETL , Pervasive , Informatica , castiron , SAP Bods , SAP BO , OBIEE etc .

Hello Sir , I am core SQL Server DBA with 10+years of experience .My main area of expertise is query tuning . I will optimize all your stored procedures to make it run super fast. I have worked primarily for Banking and Financial Customers across the Globe . I am proficient in all activities of SQL Server Administration and Development . Have worked on number of performance Tuning assignments for large customers . Expert in Query Tuning ,Server Side settings,Database Settings , Index Tuning ,Maintenance , Etc , I can do anything in SQL Server with 100% best industry standard s. By Checking your systems ,i will determine the root causes of your query slowness and assure , i will fix it for you . I guarantee you will have top notch support .Please ping me to get started . For sure you will like my support..Give me a chance . Thanks

Hi! I have more than 15 years development experience and a great team, we can complete your project with clean code and best practices Please check my profile and message me for more details. Thanks!

Hi, I have experience in programming Stored Procedure in MSSQL Server. Considering you have about 500 stored procedure to optimize, I would like to have a look at one stored procedure. I want to see how complex they are and also I would like to improve it and send it to you. That way you will also see if you are happy with my work. Regards,

Hello. I  have more then 10 years of experience in SQL Server databse development and Administration. I have worked with medium to large mission critical databases. Worked for database design and performance tuning. Specifically for performance tuning of procedures, we can focus design, indexing, joins, queries, slow query logs, unused indexes and lot more things using some dmvs and performance optimisation tools. I am also good for BI part like SSIS, SSRS and SSAS. I am immediate available to join.  I am ready to work any time zone. Thanks Anil Patel 

Hi I am SQL expert, have expereince of queries and stored procedures optimization. I also have Microsoft Certificate for SQL Server exam. If you award this project to me I'll be glad to help you

Hello. I'd really like to work on this project. I have a high efficiency working with stored procedures and optimizing them. I really think I can help you. I have 6+ years of experience on it and recently became an Microsoft Certified Solutions Associate (MCSA) on SQL 2016 Database Development. Please, let's chat. Thanks!

Hi there, I'm senior database developer with 12 years experience. I'm ready to optimize one Stored Procedure for free to prove my skills. Kind regards, Tom