SQLServerCentral: Content 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,236 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,639 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,860 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,613 reads

Missing PK and Clustered indexes

This script will find missing PK and Clustered indexes Script or Heap Tables Read more...

By G T 2010/02/25 | Source: SQLServerCentral.com | Category: clustered index

Rating:

|

Discuss |

Briefcase | 1,585 reads

Content 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

Missing PK and Clustered indexes