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

Articles with tag Indexing Rss

Search for any content tagged indexing

<< Newer    Items 21 to 40 of 166    Older >>
 

Fragmentation Fear

Index fragmentation can certainly cause performance problems, but should it really dictate the way we design our clustered indexes?  Read more...
By Tony Davis 2012/10/01 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 290 reads

Targeted Index Performance Improvements

This article identifies which indexes are used when T-SQL code runs, and proposes ways of improving these targeted indexes, leading to better performing code.  Read more...
By Ian Stirk 2012/08/03 (first published: 2009/09/17) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 41,999 reads

Introduction to Indexes: Part 3 – The nonclustered index

Part 3 of a great series on the basics of indexes. Learn the structure, definition, and how to examine the use of these indexes in your queries.  Read more...
By Gail Shaw 2012/07/23 (first published: 2009/11/18) | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 47,818 reads

Introduction to Indexes: Part 2 – The clustered index

In the second part of her series on indexing, MVP Gail Shaw examines clustered indexes. Learn what this index is, how it differs from a heap, and how it can help your queries.  Read more...
By Gail Shaw 2012/07/06 (first published: 2009/11/11) | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 55,664 reads

Indexes, Indexes, Indexes

This article has a description of an index utilization tool that Ron Johnson uses to analyze the effectiveness and use of indexes in a system.  Read more...
By Ron Johnson 2012/07/04 (first published: 2011/07/05) | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 18,890 reads

Introduction to Indexes

Indexes are critical to good performance. However many people don't understand how indexes well. MVP Gail Shaw provides us with an introductory article on the basics of indexing.  Read more...
By Gail Shaw 2012/06/29 (first published: 2009/10/26) | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 89,546 reads

Stairway to SQL Server Indexes: Level 15, Indexing Best Practices

Dos and don’ts that lead to a healthy, well-performing database.  Read more...
By David Durant 2012/03/28 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 15,569 reads

Stairway to SQL Server Indexes: Level 14, Index Statistics

A look at the information that helps SQL Server make better decisions.  Read more...
By David Durant 2012/03/16 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 9,934 reads

Stairway to SQL Server Indexes: Level 13, Insert Update Delete

What happens to your indexes during normal database activity?  Read more...
By David Durant 2012/02/29 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 10,200 reads

Stairway to SQL Server Indexes: Level 12, Create Alter Drop

Options and impacts when creating, altering and dropping an index  Read more...
By David Durant 2012/02/17 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 8,447 reads

Tips to optimize your SQL statements

Don't blame SQL Server if your SQL Statements perform badly! But where do you start to investigate the problem? This article is a primer on were to start looking when your SQL runs slowly.  Read more...
By Brian Ellul 2012/02/10 (first published: 2010/07/29) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 40,692 reads

Rebuilding SQL Server indexes using the ONLINE option

As each year goes by the uptime requirement for our databases gets larger and larger, meaning the downtime that we have to do maintenance on our databases is getting smaller and smaller. This tip will look at a feature that was introduced in SQL Server 2005 that allows us to leave our indexes online and accessible while they are being rebuilt.  Read more...
By Additional Articles 2012/02/08 | Source: MSSQLTips.com | Category: indexing
Rating: (not yet rated)  Rate this |   Briefcase | 3,638 reads

Stairway to SQL Server Indexes: Level 11, Index Fragmentation

Internal and external fragmentation – Causes, cures, and when not to care  Read more...
By David Durant 2013/11/27 (first published: 2012/02/01) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 18,299 reads

Indexing - Take the Hint and Leave it to the Experts

The most common T-SQL command in use has to be the SELECT statement, it is the bedrock of any SQL Professional's day. Sometimes it's used to snatch some data from a table or two while some quick investigation is done, other times it is at the heart of a stored procedure or view that will inform business decisions for coming months or even years.  Read more...
By Additional Articles 2012/01/30 | Source: SimpleTalk | Category: indexing
Rating:  Rate this |   Briefcase | 4,169 reads

Stairway to SQL Server Indexes: Level 10, Index Internal Structure

A detailed look the B-Tree structure – Leaf level and non-leaf level.  Read more...
By David Durant 2012/01/20 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 12,143 reads

Reduce heap table fragmentation

A table that does not have a clustered index is referred to as a Heap. While a lot has been written about index fragmentation and how to defrag indexes, there is not much that talks about how to defrag a heap table.  Read more...
By James Serra 2011/12/13 | Source: SQLServerCentral.com | Category: defragmentation
Rating: (not yet rated)  Rate this |   Briefcase | 4,759 reads

Using a Clustered Index to Solve a SQL Server Deadlock Issue

At some time or another every DBA has been faced with the challenge of solving a deadlock issue in their SQL Server database. In the following tip we will look at how indexes and more specifically clustered indexes on the right columns can help reduce the chance of your applications receiving this dreaded error  Read more...
By Steve Jones 2011/11/01 | Source: MSSQLTips.com | Category: indexing
Rating:  Rate this |   Briefcase | 4,027 reads

Stairway to SQL Server Indexes: Level 9, Reading Query Plans

Determining how, and if, SQL Server is using your indexes.  Read more...
By David Durant 2011/10/05 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 12,333 reads

Stairway to SQL Server Indexes: Level 8, Unique Indexes

Indexes that ensure data integrity in addition to locating rows.  Read more...
By David Durant 2011/09/14 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 10,444 reads

SQL Server Index Statistics

Are your index statistics up to date? The SQL Server database engine uses statistics to determine which execution plan to use when a query is compiled. Index statistics are used to help the SQL Server engine determine the cardinality of different column values in a SQL Server table. If you want to give SQL Server a fighting chance at picking an optimal execution plan then you need to make sure you maintain your index statistics.  Read more...
By Additional Articles 2011/09/14 | Source: Database Journal | Category: indexing
Rating: (not yet rated)  Rate this |   Briefcase | 3,322 reads
<< Newer    Items 21 to 40 of 166    Older >>