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
What is DMAIC and DMADV? The Six Sigma has two key methodologies viz. DMAIC and DMADV. The DMAIC is used to improve an existing business process. While DMADV is used to create

How to Enable ASP.NET polling? All our database side is configured in order to get the SQL Cache working in the ASP.NET side we require to do some configuration in the web.conf

What is Extensible Markup Language (XML). XML is an easy and flexible mark-up language in the text format. Nowadays, it is widely used to exchange a large variety of data over

I need to Develop a real state website We want a programmer who can create a website using html5, css3, jQuery, php, MySQL. All connected to a CRM to accomplish all the informat

How can we identify that the Page is PostBack? The Page object has the "IsPostBack" property which can be checked to know that the page is posted back.

Create a Calculator application using Web Form with the following functions: 1.  Add 2.  Minus 3.  Multiply 4.  Divide Each of the above has to be a Web Service

Question: (a) Explain the Postback process as use with Web Forms. (b) Write extract codes to demonstrate how to store and retrieve values in: (i) a Session Object (ii)

I need a project which shows Paypal integration with ASP.net website We have events website written in C# and ASP.net. We want to integrate Paypal using API and have a full inte

What is the difference between "DataSet" and "DataReader"? The major differences between "DataSet" and "DataReader" are as follows:- 1)The "DataSet" is a disconnected archit

What does Address Of operator do? The Address Of operator generates a delegate object for the BackgroundProcess method. A delegate within VB.NET is a object-oriented, type-safe