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

Content with tag clustered index Rss

   Items 1 to 8 of 8   
 

Why Primary Keys can be important on large tables

I inherited a database that was getting large and not performing well. After adding primary keys life got better.  Read more...
By Ben Kubicek 2014/06/30 | Source: SQLServerCentral.com | Category: primary key
Rating: |  Discuss |   Briefcase | 9,289 reads

Get the all the tables on the server which do not have Clustered index

Get the list of the tables on the server which dont have the clustered index.  Read more...
By Mitesh Oswal 2014/02/24 | Source: SQLServerCentral.com | Category: clustered index
Rating: |  Discuss |   Briefcase | 1,186 reads

Tables and Clustered Indexes Part 2

A table does not so much 'have' a clustered index as a table 'is' a clustered index.  Read more...
By Hakim Ali 2013/07/22 | Source: SQLServerCentral.com | Category: clustered index
Rating: |  Discuss |   Briefcase | 6,333 reads

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 | 8,182 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 | 4,138 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 | 13,006 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,707 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,638 reads
   Items 1 to 8 of 8   
 
Tags
heap (2)    
primary key (pk) (2)    
bookmark lookup (1)    
b-tree (1)    
covering indexes (1)    
dbcc dropcleanbuffers (1)    
dbcc freeproccache (1)    
execution plans (1)    
heap table (1)    
index (1)    
indexed views (1)    
non clustered indexes (1)    
nonclustered index (1)    
non-clustered index (1)    
primary key (1)    
sort operator (1)    
surrogate key (1)