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 the DataContext class and how is it related to LINQ? After you add a LINQ to SQL Classes item to a project and open the O/R Designer, the empty design surface shows an

C# API to grab option price from CBOE web site Project Description: On the web page below, user will download option prices of Stock or Index. For example, if you put "VXX" i

What is Thread.Sleep() The Thread's execution can be paused by calling Thread.Sleep method. This Thread.Sleep() method takes an integer value which  determines how long the thr

What does Xml Validating Reader class do? The XmlTextReader class does not validate the contents of an XML source against a schema. The correctness of the XML documents can be

Media Player App Development for Windows 8.1 platform with outstanding UI, flexible controls and simple to use. The app should be consist of 1. Normal player controls 2. s

Asp.net expert and simple html I am not new to the industry. I am seeking a long term asp.net developer to build and maintain a volleyball player management website. We would

Import Columns of Data into Data Table for Data Grid View in C# and WPF Need help with a project in C# / WPF. Trying to read a csv file or text file with columns of data that wi

What is Query String and what are their benefits and limitations? The query string is the information sent to the server appended to the end of a page URL. The benefits of u

Project Description: Take a CSV of Canadian street addresses. For every address, translate the address into a GPS coordinate. Use the GPS coordinate to test whether or not the a

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