Cancelled

SQL Server 2008

We are working on a .Net project in which we are using SQL Server 2008 as a database for Online processing and reporting. The tables are normalized and the same tables are used for Online processing and reporting. The screens are designed and developed using .Net technology (aspx pages). We don’t have SQL’s in the pages. All access to the database is done using Stored Procedures. Currently we have only one database. Historical records are stored in the same table. There can only be one current record in a table. We don’t do physical deletes, only logical deletes. We use effective date, end date and a flag for differentiating between current record versus historical record versus logical deleted records.

We have approximately 30 tables that we have created and are using 10 tables from Microsoft .Net User Management application. All these tables are in the same database. We have many stored procedures that we have written. In most of the tables we have created Primary Key’s but no index has been created. We will be adding another 40-50 tables in next couple of months and many more stored procedures.

We are looking at the following task to be accomplished as part of this project. I am looking for someone who has worked on similar tasks before and who is willing to work full time on this project. The query execution time should be excellent. I am attaching couple of tables and stored procedures to give you an idea.

• Review the table layout and suggest if we should create relationships between tables by using Primary Key and Foreign Key

• Based on the suggestion and if required create relationship between tables by using Primary Key and Foreign Key

• Generate a data model in pdf format showing all the relationship

• Look at all the stored procedures to make sure that the stored procedures follows industry best practices and is consistent. Check for redundant stored procedures.

• Look at all the Select queries in the Stored Procedure for the access path to come up with the index requirements

• Create Indexes on the tables

• Optimize the queries for response time. If required modify the query to improve the performance without impacting the business logic.

• Create partition if required. This may not be required now because of the size of the database.

• Database and table sizing based on the projected volume

• Create backup and restore procedures of the database/tables. This procedures should be configurable. The configuration should have at minimum the following parameters: Date, Time, Table Name to backup, Comb-Id (this id identifies an entity and is in all the tables), Entity Name (derived based on Comb-Id).

• We should be able to schedule the data backup or do the data backup in real time. I would like to know the impact of real time backup on the Online processing system.

• Document all the stored procedures. I would like to see in documentation the following: Stored Procedure Name, Input, Output, Tables Used and Function (Select, Insert, Update, Delete)

• Suggest a road map for the new tables and stored procedures.

[REMOVED BY GAF ADMIN]

Thanks,

Tuhin Verma

Skills: SQL

See more: which of the following is not part of configuration management, sql database business, online document review, online business by net, microsoft online business, management couple required, input data part time online, execution table, c versus c++, configuration management.net, configuration management .net, best path, best idea for online business, application server configuration, t-sql with, t-sql in, sql server or, sql server online, SQL Server Admin, sql microsoft access, server technology, online sql server, online sql, on sql, modify pdf online

About the Employer:
( 0 reviews ) Reno, United States

Project ID: #496874

6 freelancers are bidding on average $575 for this job

BSoftTech

Hi, I've expertise in SQL server with Stored procedures and SQL Optimization I can work on your requirement to fine tune and optimize your queries, and all db objects. Please send more details. The samples attached More

$700 USD in 10 days
(0 Reviews)
0.0
Rajatmodi

There is problem in your attached files. Please do check it and let us know. We have some database experts in our team who can provide you a perfect solution and of course within your time limits as well as great p More

$600 USD in 10 days
(0 Reviews)
0.0
bijubalan1234

I have worked very much on this type of scenario and I can assure you utmost quality as per Industry Standards. IF you are interested in my profile please contact me. I Can assure you quality and delivery at time. I More

$600 USD in 10 days
(0 Reviews)
0.0
emPowerelearning

I have been working as software developer since 5 years and very well versed SQL Server Applications.

$550 USD in 8 days
(0 Reviews)
0.0
Zlogos

Dear Sir, Serious Bidder. Please check PMB. Regards

$400 USD in 0 days
(0 Reviews)
0.0
cfdmo

Hi, I do not understand exactly your need. Do you need someone who improve and tune what you have or do you need someone who can develop all you mentioned in the project? Best Regards

$600 USD in 30 days
(0 Reviews)
0.0