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


Upload Image Close it
Select File

Towards the innovative SQL ideas
Browse by Tags · View All
sql server 124
sql 123
ms sql server 118
ms sql 117
database 108
tsql 80
#SQL Server 78
t-sql 74
#sql 71
sql server general 66

Archive · View All
April 2011 14
July 2011 12
May 2011 12
August 2011 11
June 2011 10
September 2011 8
December 2011 6
November 2011 6
September 2013 5
June 2013 5

Using Covering Index and Performance Review - a new Index type of SQL Server 2005

Aug 25 2013 12:00AM by Paresh Prajapati   

We all are know about the indexes and concept of it. As well as types of the indexes.During working one query optimization, i got suggested by SQL Server Optimizer with index creation and that index was Covering index.

What is covering index?

It is an additional index with include columns in definition which are exists in select list. Per msdn and book online, The term covering index does not mean a separate kind of index having a different internal structure. Rather, this term is used to describe a certain technique that is used to improve performance . It will better if we go through the demo and example. Let us start with objects creation,

Continue Reading...

Tags: Administration,DBA


Paresh Prajapati
6 · 23% · 7533
2
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect



Submit

Your Comment


Sign Up or Login to post a comment.

"Using Covering Index and Performance Review - a new Index type of SQL Server 2005" rated 5 out of 5 by 2 readers
Using Covering Index and Performance Review - a new Index type of SQL Server 2005 , 5.0 out of 5 based on 2 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]