Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

Learn about SQL Server DBA, SQL Server database performance,SQL Server optimisation,database tuning,t-sql,ssis
Browse by Tags · View All
DBA Scripts 51
performance 37
SQL Server 29
Object Management 24
#SQLServer 24
Backup and Restore 20
Security Management 20
Powershell 17
Indexes 14
DBA 14

Archive · View All
June 2011 38
January 2011 33
May 2011 32
August 2011 27
July 2011 26
January 2012 24
February 2011 19
April 2011 19
March 2011 17
March 2012 17

Jack Vamvas's Blog

SQL Server non-clustered index checklist

May 21 2011 6:35AM by Jack Vamvas   

When to create a SQL Server non-clustered index? How do non-clustered indexes sit with SQL Serrver clustered indexes?

It’s not the purpose of this post to describe a SQL Server non-clustered index, which you will find in BOL

Firstly, the main differences with between SQL Sever Clustered Index and non-clustered indexes are:

1) The clustered index sorts table data on physical

2) Non-clustered indexes “point” back to the clustered indexes data pages

A checklist for SQL Server non-clustered indexes. It is important that all index definitions are profiled with the nature of the usage and query demands.

1) In a WHERE clause, if exact matches are returned, add a non-clustered index

2) If the result sets are small create a non-clustered index. If the result sets are large more data pages are read – therefore performance may degrade with a non-clustered index.

3) Look for distinct value groupings that are not found in a clustered index, such as name and date of birth

4) Foreign key columns with joins not in the clustered index

These are general guidelines, test all implementations of indexes against real data sets and queries. Don’t forget to maintain SQL Server statistics

Republished from http://www.sqlserver-dba.com.


Republished from SQL Server DBA [65 clicks].  Read the original version here [32134 clicks].

Jack Vamvas
5 · 26% · 8528
0
Liked
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect



Submit

Your Comment


Sign Up or Login to post a comment.

    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]