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

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,194 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,623 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 | 7,885 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,629 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,526 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,229 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,141 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,128 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,649 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 | 3,940 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,285 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 | 9,641 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,267 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,400 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,112 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,194 reads

Stairway to SQL Server Indexes: Level 6, Bookmarks

A nonclustered index entry consists of search key columns, included columns, and the bookmark. The bookmark value will be either a RID or the clustered index's key, depending upon whether the table is a heap or a clustered index. Choosing the best clustered index for a table requires that you follow three guidelines to ensure that the index key will make a good bookmark.  Read more...
By David Durant 2011/08/03 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 10,987 reads

Speeding Up Database Access Part 3 - Fixing Missing Indexes

Learn how to add those indexes you need in part 3 of Matt Perdeck's 8 part series on improving data access. This is based on the book ASP.NET Site Performance Secrets.  Read more...
By mperdeck 2011/08/02 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 8,435 reads

Speeding up Data Access Part 1 - Missing Indexes

In the first part of this series, learn how to pinpoint missing indexes in your databases.  Read more...
By mperdeck 2011/07/19 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 16,876 reads

Stairway to SQL Server Indexes: Level 5, Included Columns

Included columns enable nonclustered indexes to become covering indexes for a variety of queries, improving the performance of those queries and with the only overhead being an increase the size of an index.  Read more...
By David Durant 2011/07/13 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 13,359 reads
<< Newer    Items 21 to 40 of 160    Older >>