SQLServerCentral - Guest Columnist: Sarvesh Singh

Learn the basic usage of DISTINCT in this article. Read more...

By Sarvesh Singh 2011/02/08 | Source: SQLServerCentral.com | Category: distinct

Rating:

|

Briefcase | 21,880 reads

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:

|

Briefcase | 21,352 reads

This short article shows the importance of order of columns in an index. Read more...

By Sarvesh Singh 2010/11/23 | Source: SQLServerCentral.com | Category: indexing

Rating:

|

Briefcase | 12,307 reads

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:

|

Briefcase | 21,825 reads

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:

|

Briefcase | 4,498 reads