I have a application running in .NET The application uses MS SQL Server as as the database. It has about 30 Tables and 30 Stored procedures. The Stored procedure functionality is complete. 500 Clients would connect at any point of time. I need all FINE TUNNING TIPS On issues like a) Fine Tunning the Database for 500 Clients b) Principles of Stored Procedure so that the Performance is on best c) To use or not to use Cursors in the Stored procedures d) Nested Stored procedures e) There are no Triggers in the Database etc..
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.
MS SQL Server