Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Guest Columnist: Sarvesh Singh

SQLServerCentral.com profile

   Items 1 to 5 of 5   
 

SQL DISTINCT on Multiple Columns

Learn the basic usage of DISTINCT in this article.  Read more...
By Sarvesh Singh 2011/02/08 | Source: SQLServerCentral.com | Category: distinct
Rating: |  Discuss |   Briefcase | 22,410 reads

Indexed Views

This article will show you the importance of Indexed Views and how they can help performance.  Read more...
By Sarvesh Singh 2013/05/10 (first published: 2010/11/16) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 23,969 reads

Column Order in an Index

This short article shows the importance of order of columns in an index.  Read more...
By Sarvesh Singh 2013/07/05 (first published: 2010/11/23) | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 20,467 reads

A Check and Foreign Key Constraint Improves Query Performance

Check and foreign key constraint do not degrade performance but actually improve it.  Read more...
By Sarvesh Singh 2013/04/26 (first published: 2010/10/21) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 23,135 reads

Restore from LiteSpeed

Learn how to restore a LiteSpeed backup on a server without the software in 2 Simple Steps.  Read more...
By Sarvesh Singh 2010/10/12 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 4,657 reads
   Items 1 to 5 of 5