SQLServerCentral.com Content tagged Indexing

Stairway to SQL Server Indexes

Thu, 17 Feb 2011 07:00:00 UT

Indexes are fundamental to database design, and tell the developer using the database a great deal about the intentions of the designer. Unfortunately indexes are too often added as an afterthought when performance issues appear. Here at last is a simple series of articles that should bring any database professional rapidly 'up to speed' with them

Tips to optimize your SQL statements

Fri, 10 Feb 2012 07:00:00 UT

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.

Stairway to SQL Server Indexes: Level 11, Index Fragmentation

Wed, 01 Feb 2012 07:00:00 UT

Internal and external fragmentation – Causes, cures, and when not to care

Indexing - Take the Hint and Leave it to the Experts

Mon, 30 Jan 2012 07:00:00 UT

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.

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

Fri, 20 Jan 2012 07:00:00 UT

A detailed look the B-Tree structure – Leaf level and non-leaf level.

SQL Server Backup, Integrity Check, Index and Statistics Maintenance

Thu, 19 Jan 2012 07:00:00 UT

Solution for Backup, Integrity Check, Index and Statistics Maintenance in SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2.

Script foreign keys

Tue, 10 Jan 2012 07:00:00 UT

Using this script you can create a list of sql commands for foreign keys manipulation.

Find Unindexed Foreign Keys (2005)

Tue, 20 Dec 2011 07:00:00 UT

This script will find foreign keys (on referencing table) that are not indexed in SQL Server 2005.

Reduce heap table fragmentation

Tue, 13 Dec 2011 07:00:00 UT

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.

SQL Server Backup, Integrity Check, Index and Statistics Maintenance

Thu, 19 Jan 2012 07:00:00 UT

Solution for Backup, Integrity Check, Index and Statistics Maintenance in SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2.

The Future of SQL Server Monitoring
Monitor wherever, whenever with Red Gate's SQL Monitor. See it live in action now.

INDEX DEFRAGMENTATION SCRIPT

Wed, 30 Nov 2011 07:00:00 UT

Index Defragmentation is one of the most important DBA tasks. This will significantly improve query performance.

Using a Clustered Index to Solve a SQL Server Deadlock Issue

Tue, 01 Nov 2011 06:00:00 UT

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

Get smart with SQL Backup Pro
Powerful centralised management, encryption and more.
SQL Backup Pro was the smartest kid at school.
Discover why.

SQL Server 2005 Index Maintenance

Wed, 26 Oct 2011 06:00:00 UT

Index maintenance procedure using rebuild or reorganized based on fragementation level.

Index Fragmentation

Fri, 21 Oct 2011 06:00:00 UT

This stored procedure is capable of performing defragmentation indices with avg_fragmentation_in_percent greater than the threshold passed.

Indexes

Thu, 06 Oct 2011 06:00:00 UT

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

Wed, 05 Oct 2011 06:00:00 UT

Determining how, and if, SQL Server is using your indexes.

Generate Create All Secondary Indexes For Entire Database

Fri, 23 Sep 2011 06:00:00 UT

Generate Script to create all secondary indexes for a database. I have included the ability to generate online indexes if possible and the ability to move to another file group.

Stairway to SQL Server Indexes: Level 8, Unique Indexes

Wed, 14 Sep 2011 06:00:00 UT

Indexes that ensure data integrity in addition to locating rows.

SQL Server Index Statistics

Wed, 14 Sep 2011 06:00:00 UT

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.

Are remote databases fragmented? Let's Defrag.

Mon, 12 Sep 2011 06:00:00 UT

This article shows an automated reorg/rebuild index for remote servers with notifications for the DBA.

Get Smart with SQL Backup Pro
Powerful centralised management, encryption and more.
SQL Backup Pro was the smartest kid at school
Discover why.

List all tables without LOB columns

Tue, 30 Aug 2011 06:00:00 UT

Lists all the tables in a database that do not contain any LOB columns(text, ntext, image, varchar (max), nvarchar (max), varbinary (max) and xml). Useful when rebuilding indexes online.

Stairway to SQL Server Indexes: Level 7, Filtered Indexes

Wed, 24 Aug 2011 06:00:00 UT

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.

SQL Server Backup, Integrity Check, Index and Statistics Maintenance

Thu, 19 Jan 2012 07:00:00 UT

Solution for Backup, Integrity Check, Index and Statistics Maintenance in SQL Server 2005, SQL Server 2008 and SQL Server 2008 R2.

SQL Server Index Maintenance Performance Tuning for Large Tables

Thu, 18 Aug 2011 06:00:00 UT

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.

Reindex - Reorganize or Rebuild

Wed, 10 Aug 2011 06:00:00 UT

In the first time you execute this procedure, might take a long time, but not in the next time. Later you can execute this procedure daily.

Page split - 2

Mon, 08 Aug 2011 06:00:00 UT

Stairway to SQL Server Indexes: Level 6, Bookmarks

Wed, 03 Aug 2011 06:00:00 UT

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.

DBCC INDEXDEFRAG

Tue, 02 Aug 2011 06:00:00 UT

Speeding Up Database Access Part 3 - Fixing Missing Indexes

Tue, 02 Aug 2011 06:00:00 UT

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.

Get Smart with SQL Backup Pro
Powerful centralised management, encryption and more.
SQL Backup Pro was the smartest kid at school
Discover why.

Speeding up Data Access Part 1 - Missing Indexes

Tue, 19 Jul 2011 06:00:00 UT

In the first part of this series, learn how to pinpoint missing indexes in your databases.