Checking Sql server Database

Posted Date: 27 Oct 2009	Resource Type: Articles	Category: Databases
Author: Rajesh.Dharmakkan	Member Level: Gold
Rating:	Points: 7

Checking Sql server Database

Some important points which should be consider while developing or testing the database. This points will used to improve the performance of the database.

1. Checking the index is implemented in the table, if else then implement the indexes in a table.
2. Validate the table column names and the data stored in the columns. The values in a column should be validate.
3. Check the constraints which are implemented in the table. The constraints are the important think for data integrity.
4. Check all the database objects like Stored procedures, Tables, Triggers, functions and all. Check all objects with its outputs.
5. Check the Front end and Back end data types and the field lengths. This testing will done only after developed application.

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

Test database . Piont to develop database . Check database .

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: Datatype conversion in SQL Server
	Previous Resource: Fill factor in Index
	Return to Discussion Resource Index
	Post New Resource
	Category: Databases

Post resources and earn money!

More Resources