SQL query efficiency and troubleshooting

Hello Sir, I am an expert with Sql queries and interested in this project. Btw, it may not only be the problem with Sql but one needs to look at database as well for optimization purposes. Thanks Aanvik

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. The bid may be changed according to the queries they need improvement. Best Regards mpalgeo

I have more than 10 years of experience in SQL Server. Expert in T-SQL, I am a MCSA SQL Server 2014 certified professional. I can have the job done in 2 working days, tops. Relevant Skills and Experience T-SQL: advanced English: near-native Proposed Milestones $160 USD - Job done

I am sql server dba having more then 10 yrs of experience, I will improve speed by optmizing your database and improve sql query performance

Hi, I can help you with your queries. But i need to understand your db structure, your queries and your issues. Competenze ed esperienze rilevanti I am .net/sql server developer Pietre Miliari proposte $222 USD - Task Please share me more details

Hi I am good in Relevant Skills and Experience 1 Proposed Milestones $155 USD - 1 1

A proposal has not yet been provided

Can you send me queries to analyze it Relevant Skills and Experience Microsoft SQL Server, SQL Proposed Milestones $155 USD - SQL queries

A proposal has not yet been provided

10 years experience in database.

A proposal has not yet been provided

I am an experienced software engineer with a strong SQL background. Relevant Skills and Experience SQL Proposed Milestones $155 USD - Identify bottlenecks and remove them to increase the efficiency

A proposal has not yet been provided

Let's try together.

A proposal has not yet been provided

hi dear, i can test, fix find out root cause of mysql query issue. i am expert on mysql performance tuning. can you please share mysql version and operating system name. i can start immediately. hope i will do this job for you.

A proposal has not yet been provided

hi bos, we are available to work on the project Relevant Skills and Experience ms sql server (from 2005) Proposed Milestones $50 USD - check the database to confirm for the normalization process $50 USD - check all the indexes, statistics and constraints to make the queries faster $100 USD - check all the queries and modify or re write if necessary

I can able to tune the queries and improve the performance of the queries Past 3 yrs am working on the PLSQL scripts so it will be easily for me to tune & help on your requirement. Thanks in advance Relevant Skills and Experience Working as PL SQL developer for past 3 years and having great knowledge on performance tunning

well ,i'm a good sql developer my last experience in Business intelligence and sql server query allows me to take this job if you accept me of course. Relevant Skills and Experience sql server query Business intelligence implementing Data warehouse Proposed Milestones $155 USD - optimizing those queries by using sql set statement, sql server analyzer ,exeucution plan, indexes Additional Services Offered $10 USD - i will be in your service for any kind of problems you will have in future