How to increase sql performance?, DOT NET Programming

How can you increase SQL performance?

1)Keep your indexes as narrow as possible. This reduces the size of the index and decrease the number of reads needed to read the index.

2)Try to create indexes on the columns that have integer values rather than the character values.

3)If you create a composite (multi-column) index, then the order of the columns in the key are much important. Try to order the columns in the key as to enhance the selectivity, with the most selective columns to the leftmost of the key.

4)If you want to join several tables, try to generate surrogate integer keys for this purpose and create indexes on their columns.

5)Create the surrogate integer primary key (identity for example) if your table will not have many insert operations.

6)The Clustered indexes are more preferable than nonclustered, if you require to select by a wide range of values or you need to sort results set with GROUP BY or ORDER BY.

7)If your application will be performing the same query over and over again on the similar table, consider creating a covering index on the table.

8)You can use the SQL Server Profiler Create Trace Wizard with "Identify the Scans of the Large Tables" trace to determine which tables in your database may need indexes. This trace will show which tables are being scanned by queries in spite of using an index.

Posted Date: 9/24/2012 4:29:13 AM | Location : United States

Related Discussions:- How to increase sql performance?, Assignment Help, Ask Question on How to increase sql performance?, Get Answer, Expert's Help, How to increase sql performance? Discussions

Write discussion on How to increase sql performance?
Your posts are moderated
Related Questions
In search of urgent assistance with loading an website In search of assistance with loading an website installation onto a new server, job will start nearly D

What is an XMLReader Class? This is an abstract class available from the System.XML namespace. The XML reader works on a read-only stream browsing from one node to another in a

Bug Correction and Prediction Project Description: The project is about the prediction of bugs and resolves the bug in the sample program using costriage algorithm. You have

What is DAR (Decision Analysis and Resolution)? The Decision Analysis and Resolution is to analyze possible decisions using a formal evaluation process that identifies alternat

Give a small explanation of all Elements in the diagram. Action State: - This is a type of state that has an internal action and one outgoing event that would do the int

Why isn''t there an allowed amount for nonfacility for code 27405?

Question: (a) The ObjectDataSource control is an alternative design approach to using AccessDataSource or SqlDataSource controls. Explain and illustrate how an ObjectDataSourc

What is the meaning of object pooling? Object pooling is a method of storing a pool (group) of objects in memory that can be reused later as needed. Whenever, a new object is n

how make the google sign up page?