Tag: Performance Tuning

Database Optimization Techniques to Increase SQL SERVER Performance – Part III – Index on multiple columns

Index on multiple columns for SQL performance Since clustered index records the table and arranges the data according to the index key, SQL Server allows only one clustered index per table. This results in amazing performance and the worry arises when you need to order the data by more than one column. Since we can’t use clustered index for multiple columns, a unclustered index is used to gain an increase in performance. We can specify a key value …

Database Optimization Techniques to Increase SQL SERVER Performance – Part I – Increase SQL Server stored procedure performance

1) Increase SQL Server stored procedure performance with following three tips: Stored procedures play a vital role in enhancing the performance of the database. The following three tips will help us to maximize database performance when stored procedures are used. Use NOCOUNT: If NOCOUNT option is turned off, on each operation: stored procedures returns information concerning the number of rows affected and it increases network overhead. By default, the Option NOCOUNT will be turned off.  If we turn …