SQLServerCentral: Articles tagged clustered index

Can a Table Really Have a Clustered Index?

A table doesn't so much "have" a clustered index as a table "is" a clustered index. Read more...

By Hakim Ali 2012/12/24 | Source: SQLServerCentral.com | Category: bookmark lookup

Rating:

|

Discuss |

Briefcase | 7,235 reads

SQL Server Tables without a Clustered Index

It is a general best practice to have a clustered index on all of your SQL Server tables. Unfortunately, not everybody knows that. This tip helps you find tables that do not have a clustered index. Read more...

By Additional Articles 2011/10/06 | Source: MSSQLCity.com | Category: clustered index

Rating: (not yet rated) Rate this |

Briefcase | 3,638 reads

Do You Really Need Surrogate Keys? Part 1 – Concepts and Methods

This is the first of a series of articles to analyze the use of surrogate keys in different scenarios. Read more...

By Wagner Crivelini 2010/10/25 | Source: SQLServerCentral.com | Category: primary key (pk)

Rating:

|

Discuss |

Briefcase | 12,859 reads

Ways to minimize sort operations

In this article Brian Ellul explorea how it's possible to eliminate the SORT operator (and its performance cost) on performing SELECTS statements. Read more...

By Brian Ellul 2010/09/15 | Source: SQLServerCentral.com | Category: sort operator

Rating:

|

Discuss |

Briefcase | 10,612 reads

Articles with tag clustered index

Can a Table Really Have a Clustered Index?

SQL Server Tables without a Clustered Index

Do You Really Need Surrogate Keys? Part 1 – Concepts and Methods

Ways to minimize sort operations