Microsoft SQL Server 2000 Tunning Techinques by Vikram Lashkari

As far I have understood the Microsoft SQL SERVER 2000 from my practical experience, i can give the following tips as a DBA ( Database Administrator).

* Always try to make use of the Stored Procedure as the use of the stored procedure is very effective and helpful for the databsae management

While designing the Tables make sure that you make the the primary key to that field which is being mostly used for join with the other table or in simple words that key has to be foreign key in other table

Try to take advantage of the Indexes. Generally the field which is primary key in a table is by default clustered index but as per the need you can change that .but from my experience that technique is good

Making indexes on the table is not always good. Sometime if you have created wronng on the wrong field then it can give performance degrade instead of performace boost.

In Order to review the performance of you queries or Stored procedure always make use of the Execution plan given on the Query analyzer



Some other technique for the table design in a database are described as under

1) Create the staff or account kind of the table that will be used as the main login assingment table and work on that staff_key or account _key while you want to record any audit entry of any transaction by that staff or account

2)As per the Enterprise Resourse Planning Standard we should never ever delete the records which are entered by the users of the software or web application. so in this case in order to get track of the acitive and the deleted records you can create on tinyint field on each table to assign state of the record. Say for example you can add the state field in each and every table of the database and  assign enum  for each state. ACTIVE RECORDS =1 and DELETED RECORDS=0 and so in any case if you want to know how any active records are there in particulare table then you can fire the query like this

Select [field_list]  from [table_name] where state=0





you can go to my home page by clicking Vikram Engineer