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 11 of 11   
 

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,732 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,215 reads

When SQL Server Nonclustered Indexes Are Faster Than Clustered Indexes

SQL Server Clustered indexes can have enormous implications for performance of operations on a table. But are there times when a SQL Server non-clustered index would perform better than a clustered index for the same operation? Are there any trade-offs to consider? Check out this tip to learn more.  Read more...
By Additional Articles 2013/10/10 | Source: MSSQLTips.com | Category: clustered index
Rating:  Rate this |   Briefcase | 5,609 reads

Primary Keys which are not Clustered Indexes in a database

Recently I was asked to find all the Primary keys that are not clustered Indexes in the database. I constructed the below script which will help us to locate the primary keys in the database which are not clustered index.  Read more...
By Bodhisatya Mookherjee 2013/09/18 | Source: SQLServerCentral.com | Category: primary keys
Rating: |  Discuss |   Briefcase | 1,806 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,344 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,191 reads

A google like search

A conceptual proof for a google like search procedure  Read more...
By Jean Bulinckx 2012/02/02 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 3,457 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,278 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,009 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,712 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,639 reads
   Items 1 to 11 of 11   
 
Tags
heap (2)    
non-clustered index (2)    
primary key (pk) (2)    
bookmark lookup (1)    
b-tree (1)    
covering indexes (1)    
dbcc dropcleanbuffers (1)    
dbcc freeproccache (1)    
execution plans (1)    
fnord (1)    
google (1)    
heap table (1)    
index (1)    
indexed views (1)    
indexing (1)    
non clustered indexes (1)    
nonclustered index (1)    
performance tuning (1)    
primary key (1)    
primary keys (1)    
procedure (1)    
search (1)    
sort operator (1)    
surrogate key (1)    
temporary tables (1)