This is a complicated job that requires the prowess of a DBA.
If you require a copy of the database. Please ask.
1: We need expert advice on current database design deficiencies.
2: Current database views improvements.
3: If possible then current views could be written into sql-proc.
4: Current database needs to be split on two physical servers for load balance.
5: Few tables holds large amount of data, need indexes
6: If possible then foreign key relationship between tables
7: SQL proc for pagination
8: SQL proc for other sections I will forward you the plain SQL.
9: Mainly to improve performance + load balancing
17 freelancer đang chào giá trung bình $1176 cho công việc này
Hi, We are a software engineering and web development company. Our DBA engineer will be pleased to help you in the above project. Feel free to contact us to discuss any issues. Best Regards
Hi, I specialise in SQL Server contracts, please see my CV in PM. Please note that my bid and # days are just arbitrary as I need more information to access how much work is involved.