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
I need Online Slot Video Game For A Facebook Project Description: Prepare an online slot video game for a Face book promotion in order to attract new visits and Increase the

Ask queyuyuystion #Minimum 100 words accepted#

System Simulation - repost 2 Project Description: A. Prepare random numbers of the form: Case 1: Uniformly distributed random numbers (RNs) [range: 0.0-1.0] Case 2: Exp

I need Game development tutorials Project Description: We need video tutorials like lynda for game development using unity. You must have developed games before and need to s


What is CMMI? This is a collection of instructions an organization can follow with the purpose to gain the better control over its software development process. According to

Does a Web service have state? The Web services do not have any method to maintain state. Though, it can access ASP.NET objects, such as application and session if they extend

A few changes to OutloProject Description: We require someone who is familiar with programming plug-in to work with Microsoft Outlook. Initially we just require a simple chan

What are the ways of parsing XML document? The XML parser sits in between the XML document and the application who want to use the XML document. The Parser exposes a set of wel

What are queues and stacks? Stacks refer to a list in which all items are accessed and processed on the Last-In-First-Out (LIFO) basis. In a stack, elements are inserted (push