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 164    Older >>
 

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,485 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,850 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,161 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,014 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,574 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 | 9,901 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,142 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,668 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,596 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 | 17,798 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,160 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 | 11,629 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,719 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,000 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 | 11,813 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,020 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,309 reads

Are remote databases fragmented? Let's Defrag.

This article shows an automated reorg/rebuild index for remote servers with notifications for the DBA.  Read more...
By Kimberly Killian 2011/09/12 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 3,405 reads

Stairway to SQL Server Indexes: Level 7, Filtered Indexes

A filtered index eliminates unusable entries from the index, producing an index that is as beneficial as, but much smaller than, an unfiltered index. If a certain subset of a table's data is frequently requested, a filtered index can also be a covering index; resulting in a considerable reduction in IO.  Read more...
By David Durant 2011/08/24 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 11,540 reads

SQL Server Index Maintenance Performance Tuning for Large Tables

If you think about it carefully, you’ll realise, that index maintenance is necessary and that it makes sense, and that SQL Server is not doing this task automatically according to the book.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 4,301 reads
<< Newer    Items 21 to 40 of 164    Older >>