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

SQL Server - Which Indexes will be used?

Aug 6 2011 12:00AM by Paresh Prajapati   

During the performance issues of database servers and database itself, one of my activity to improve performance of the Indexes. I have created some of the clustered indexes on tables which have only nonclustered indexes and also on some heap tables. Also i have created some additional nonclustered indexes  called as Covering indexes and some of having composite indexes.

After creating or having so many indexes on tables, it is real time to check the usage of them as which indexes are used by execution plans or query plans among them.

Continue Reading...

Tags: sql, sql server 2008, sql server 2005, tsql, sql server, ms sql, ms sql server, t-sql, index, #SQL Server, #sql, sql server 2011, database, SQL Scripts, query,


Paresh Prajapati
6 · 23% · 7533
4 Readers Liked this
nadabadan Liked this on 8/16/2011 8:49:00 AM
Profile
Paresh Prajapati Liked this on 8/16/2011 7:08:00 AM
Profile · Blog · Facebook · Twitter
Nirav Liked this on 3/28/2012 12:46:00 AM
Profile · Blog · Facebook · Twitter
kavan dhruv Liked this on 11/12/2012 4:26:00 AM
Profile · Facebook · Twitter
4
Liked
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect



Submit

Your Comment


Sign Up or Login to post a comment.

"SQL Server - Which Indexes will be used?" rated 5 out of 5 by 4 readers
SQL Server - Which Indexes will be used? , 5.0 out of 5 based on 4 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]