SQLServerCentral.com Articles tagged clustered index

Can a Table Really Have a Clustered Index?

Mon, 24 Dec 2012 07:00:00 UT

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

SQL Server Tables without a Clustered Index

Thu, 06 Oct 2011 06:00:00 UT

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.

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

Mon, 25 Oct 2010 06:00:00 UT

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

Ways to minimize sort operations

Wed, 15 Sep 2010 06:00:00 UT

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