SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag clustered index Rss

Search for any content tagged clustered index

   Items 1 to 14 of 14   
 

NonClustered Index Structure

Learn how the clustered index keys affect the non clustered index structure.  Read more...
By Mayank Shukla 2018/06/01 (first published: 2016/04/11) | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 4,627 reads

Tables Without Clustered Indexes

When databases are being designed and developed, your developers might have overlooked creating clustered indexes on some of your database tables. Having a useful clustered index on your tables will improve the performance of your queries. Here Greg Larsen shows a simple script to identify those tables in your database that don’t have a clustered index.   Read more...
By Additional Articles 2018/05/29 | Source: Database Journal | Category: clustered index
Rating:  Rate this |   Briefcase | 4,572 reads

Where Clustered Index Keys Dare

We’ve blogged a couple times about how clustered index key columns get stored in your nonclustered indexes. But where they get stored is a matter of weird SQL trivia. You see, it depends on how you define your nonclustered index.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,421 reads

Performance Myths : Clustered vs. Non-Clustered Indexes

Aaron Bertrand kicks off his "Performance Myths" series, showing a "redundant" non-clustered index outperforming the clustered index with the same key.  Read more...
By Additional Articles 2017/04/17 | Source: SQLPerformance.com | Category: clustered index
Rating: (not yet rated)  Rate this |   Briefcase | 5,168 reads

Comparing Space Usage for Different Compression Types

This is an investigation, to get an impression on the impact of the used disk space before and after compression considering different index types.  Read more...
By Michael Salzmann 2017/03/23 | Source: SQLServerCentral.com | Category: compression
Rating: |  Discuss |   Briefcase | 749 reads

NonClustered Index Structure

Learn how the clustered index keys affect the non clustered index structure.  Read more...
By Mayank Shukla 2018/06/01 (first published: 2016/04/11) | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 4,627 reads

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 (pk)
Rating: |  Discuss |   Briefcase | 12,192 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 | 6,184 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,436 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,233 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,822 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,050 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,786 reads
   Items 1 to 14 of 14