SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
Search:  
 
 

Articles with tag Indexing Rss

Refine your search with one of the following additional tags (with number of items):

SQL Server 7, 2000 (30)     SQL Server 2008 (3)     Blogs (1)     OpenXML (1)    
Performance Tuning (18)     Basic Querying (2)     computed column (1)     Part o (1)    
Miscellaneous (10)     Basics (2)     constraints (1)     Partitioned Tables (1)    
Administration (7)     DTS (2)     deadlock (1)     Performance Monitoring (1)    
T-SQL (7)     Installation (2)     Distributed Queries (1)     RAND() (1)    
Backup and Recovery (5)     Monitoring (2)     DMV (1)     Replication (1)    
Configuring (5)     Security (2)     English Query (1)     Testing (1)    
Database Design (5)     Stored Procedures (2)     Files and Filegroups (1)     UpdateGrams (1)    
SQL Server 2005 (5)     Strategies (2)     Foreign Key (1)     Video (1)    
Programming (4)     Triggers (2)     heap (1)     Visual Basic 6 (1)    
statistics (4)     User Defined Function (UDF) (2)     Lock and Connection Management (1)     XML (1)    
Advanced (3)     Blocking (1)     Non-Clustered (1)     XSL (1)    
Fragmentation (3)    

Search for any content tagged Indexing

   Items 1 to 20 of 72    Next 20 >>
 

Introduction to Indexes: Part 3 – The nonclustered index

Part 3 of a great series on the basics of indexes. This time MVP Gail Shaw examines the non-clustered index. Learn the structure, definition, and how to examine the use of these indexes in your queries.  Read more...
By Gail Shaw 2009/11/18 | Source: SQLServerCentral.com | Category: Indexing
Rating: |  Discuss |  Briefcase | 8,522 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 2009/11/11 | Source: SQLServerCentral.com | Category: Indexing
Rating: |  Discuss |  Briefcase | 13,268 reads

An Un-indexed Foreign Key Gotcha

Indexing is important for improving performance, but do you know that a lack of indexes might actually cause things to stop working? Alok Dwivedi brings us a very interesting scenario where the lack of an index causes a problem with concurrency.  Read more...
By Alok Dwivedi 2009/11/09 | Source: SQLServerCentral.com | Category: T-SQL
Rating: |  Discuss |  Briefcase | 8,809 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 2009/10/26 | Source: SQLServerCentral.com | Category: Indexing
Rating: |  Discuss |  Briefcase | 21,929 reads

Index Management

This article demonstrates an Index Management strategy to tackle day to day performance issues due to improper indexes.  Read more...
By sql frenzy 2009/10/20 | Source: SQLServerCentral.com | Category: Indexing
Rating: |  Discuss |  Briefcase | 9,541 reads

SQL Server 2005 Index Best Practices

In continuing with our series of tips on Best Practices for SQL Server I'm turning my sights on Maintenance. Specifically in this tip we will be discussing Index maintenance: when, if, why, and how are questions that will be addressed.  Read more...
By Additional Articles 2009/10/09 | Source: MSSQLTips.com | Category: SQL Server 2005
Rating: (not yet rated)  Rate this |  Briefcase | 5,771 reads

Keep Your SQL Server Indexes Fragmentation Free

Routine maintenance can keep index fragmentation to a minimum—with some help from an index-defragmenting script.  Read more...
By Additional Articles 2009/09/22 | Source: DevX | Category: Indexing
Rating:  Rate this |  Briefcase | 4,505 reads

Back to basics: Optimizing SQL Server indexes

When created and maintained correctly, indexes help SQL Server retrieve data quickly. See how to ensure your SQL Server environment is running up to speed.  Read more...
By Additional Articles 2009/08/21 | Source: SearchSQLServer | Category: Indexing
Rating:  Rate this |  Briefcase | 6,119 reads

Retaining historical index usage statistics for SQL Server - Part 3

In this, the third of the four part series on persisting the rowset results from the indexing Dynamic Management Views cached in temporary internal SQL Server structures we will explore what is required to store the missing index-related metadata.  Read more...
By Additional Articles 2009/07/20 | Source: MSSQLTips.com | Category: Indexing
Rating:  Rate this |  Briefcase | 1,182 reads

Partitioned Table and Index Strategies Using SQL Server 2008

The Microsoft SQL Server 2008 database software provides table partitioning to make such operations more manageable.  Read more...
By Additional Articles 2009/07/10 | Source: TechNet | Category: Partitioned Tables
Rating:  Rate this |  Briefcase | 2,179 reads

Using Indexes to Reduce Blocking in Concurrent Transactions

New author Nilav Ghosh brings us a performance tuning article to help your queries run better. This article examines how indexes can help reduce blocking.  Read more...
By Nilav Baran Ghosh 2009/07/07 | Source: SQLServerCentral.com | Category: Performance Tuning
Rating: |  Discuss |  Briefcase | 11,818 reads

Retaining historical index usage statistics for SQL Server

In this three-part series I'll look at what you can do to persist this data so you don't find yourself waiting for usage stats to compile over a reasonable period of time just so you can harness the power of the indexing DMOs in your performance tuning process.   Read more...
By Additional Articles 2009/05/26 | Source: MSSQLTips.com | Category: statistics
Rating: (not yet rated)  Rate this |  Briefcase | 553 reads

SQL Server Optimization

This article describes different ways of improving the performance of SQL Server queries, with a focus on index optimization.  Read more...
By Additional Articles 2009/05/08 | Source: TechNet | Category: Performance Tuning
Rating: (not yet rated)  Rate this |  Briefcase | 4,850 reads

Don’t Make Dumb Mistakes by Duplicating Indexes

Just today, I was reviewing the indexing of a database used by a third-party application. As part of my review, I ran a script against it that is used to identify duplicate indexes. The script I used was written Paul Nielsen, the author of the SQL Server...  Read more...
By Brad McGehee 2009/04/20 | Source: SQLServerCentral.com | Category: Indexing
Rating: (not yet rated)  Rate this |  Briefcase | 2,582 reads

How to create indexes on computed columns in SQL Server

There are certain requirements for creating indexes on computed columns and this tip shows you want needs to be done.  Read more...
By Additional Articles 2009/03/18 | Source: SQLServerCentral.com | Category: Indexing
Rating:  Rate this |  Briefcase | 2,233 reads

Reasons Why You May Not Want to Use a Heap

For a book project I am working on, I have started compiling a list of reasons why heaps aren't usually a good choice when designing a database. Now, I didn't say that heaps are always bad, but in most cases, I think they should be avoided so pleae read the list to see why.  Read more...
By Additional Articles 2009/03/10 | Source: SimpleTalk | Category: Indexing
Rating:  Rate this |  Briefcase | 2,429 reads

Which is Better: Heaps or Tables with Clustered Indexes?

I have always been of the personal opinion that all SQL Server tables have a clustered index. As part of the research I am doing on a new book on High Performance Index Maintenance , and on heaps specifically, I ran across this SQL Server Best Practices...   Read more...
By Brad McGehee 2009/02/20 | Source: SQLServerCentral.com | Category: Blogs
Rating: (not yet rated)  Rate this |  Briefcase | 2,766 reads

Using DMVs to improve SQL index effectiveness

Dynamic management views measure the effectiveness of indexes and discover fragmented indexes that may slow down SQL Server.   Read more...
By Additional Articles 2009/02/18 | Source: SearchSQLServer | Category: DMV
Rating: (not yet rated)  Rate this |  Briefcase | 2,059 reads

Moving Tables and Indexes to Filegroups En Masse

Longtime author and SQL Server expert David Poole brings us a method to   Read more...
By David Poole 2009/01/21 | Source: SQLServerCentral.com | Category: Files and Filegroups
Rating: |  Discuss |  Briefcase | 5,720 reads

Disabling Indexes - SQL School Video

There are times that you do not want indexes to be updated and used. Brian Knight shows how you can accomplish this with a new SQL School video.  Read more...
By Andy Warren 2009/01/13 | Source: JumpStartTV | Category: Video
Rating: |  Discuss |  Briefcase | 1,981 reads
   Items 1 to 20 of 72    Next 20 >>
 
Most popular

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 2009/10/26 | Source: SQLServerCentral.com | Category: Indexing
Rating: |  Discuss |  Briefcase | 21,929 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 2009/11/11 | Source: SQLServerCentral.com | Category: Indexing
Rating: |  Discuss |  Briefcase | 13,268 reads

Introduction to Indexes: Part 3 – The nonclustered index

Part 3 of a great series on the basics of indexes. This time MVP Gail Shaw examines the non-clustered index. Learn the structure, definition, and how to examine the use of these indexes in your queries.  Read more...
By Gail Shaw 2009/11/18 | Source: SQLServerCentral.com | Category: Indexing
Rating: |  Discuss |  Briefcase | 8,522 reads