SQLServerCentral: Content tagged indexing

Smart Index Rebuild - All Databases

Rebuilds all indexes from all databases over a specified fragmentation threshold. Read more...

By Tim Hollobon 2012/11/08 | Source: SQLServerCentral.com | Category: indexing

Rating:

|

Discuss |

Briefcase | 1,663 reads

Partitioned Tables, Indexes and Execution Plans: a Cautionary Tale

Table partitioning is a blessing in that it makes large tables that have varying access patterns more scalable and manageable, but it is a mixed blessing. It is important to understand the down-side before using table partitioning. Read more...

By Additional Articles 2012/11/08 | Source: SimpleTalk | Category: partition table

Rating: (not yet rated) Rate this |

Briefcase | 3,716 reads

Tune Your Indexing Strategy with SQL Server DMVs

SQL Server Indexes need to be effective. It is wrong to have too few or too many. The ones you create must ensure that the workload reads the data quickly with a minimum of I/O. As well as a sound knowledge of the way that relational databases work, it helps to be familiar with the Dynamic Management Objects that are there to assist with your indexing strategy. Read more...

By Additional Articles 2012/10/23 | Source: SimpleTalk | Category: indexing

Rating:

Rate this |

Briefcase | 3,351 reads

Tables, Queues, and Indices as a Percent of DB Size

Two views that give you a variety of stats, sortable as a percent of DB size, for tables, indiceses, XML indices, and Service Broker Queues. Read more...

By Dan Moran-347932 2012/10/09 | Source: SQLServerCentral.com | Category: table size

Rating:

|

Discuss |

Briefcase | 2,885 reads

Getting Started with the New Column Store Index of SQL Server 2012

Column Store Index, a new feature in SQL Server 2012, improves performance of data warehouse queries several folds. Arshad Ali shows you how to create column store index, and how to use index query hint to include or exclude a column store index. Read more...

By Additional Articles 2012/10/09 | Source: Database Journal | Category: sql server 2012

Rating: (not yet rated) Rate this |

Briefcase | 2,691 reads

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 | 241 reads

Index Defragmentation

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

By MUTHUKKUMARAN KALIYAMOORTHY 2012/09/26 | Source: SQLServerCentral.com | Category: automated index defragmentation script

Rating:

|

Discuss |

Briefcase | 10,767 reads

Index types 2

By Hugo Kornelis 2012/08/30 | Category: indexing

Rating: (not yet rated) |

Discuss |

Briefcase | 2,546 reads

Defragment all indexes on Database

It finds the Indexes on database which needs to be Defragmented and Rebuilds those indexes. Only you need to replace 'database_name' with your database. Read more...

By Jignesh Patel 2012/08/17 | Source: SQLServerCentral.com | Category: indexing

Rating:

|

Discuss |

Briefcase | 1,869 reads

2008 Index Rebuild using DMV

Index Maintenance procedure with HTML Reporting capabilities. Please refer to attached script for detailed information. Read more...

By Tommy Bollhofer 2012/08/09 | Source: SQLServerCentral.com | Category: indexing |

SQL Scripts Manager Compatible

Rating:

|

Discuss |

Briefcase | 1,412 reads

Index types 1

By Hugo Kornelis 2012/08/06 | Category: indexing

Rating: (not yet rated) |

Discuss |

Briefcase | 2,565 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,813 reads

2005 Online Index Rebuild using DMV

Identifies indexes with average logical fragmentation >= 30% using the DM available in MSSQL 2005. Please refer to script for more information. Read more...

By Tommy Bollhofer 2012/07/31 | Source: SQLServerCentral.com | Category: sql server 2005

Rating:

|

Discuss |

Briefcase | 4,295 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 | 46,199 reads

XML index

By Ravi Kumar SV 2012/07/17 | Category: database design

Rating: (not yet rated) |

Discuss |

Briefcase | 1,957 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 | 53,504 reads

Index Types

By Haining Liu 2012/07/05 | Category: indexing

Rating: (not yet rated) |

Discuss |

Briefcase | 2,656 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,495 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 | 85,579 reads