SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag Indexing Rss

Search for any content tagged indexing

<< Newer    Items 21 to 40 of 213    Older >>
 

In-Memory OLTP - Row Structure and Indexes

There are several decisions to be made when designing indexes for Memory-optimized tables in In-Memory OLTP, and to make the best choice, it pays to understand something about the nature and usage of memory-optimised indexes. Murilo Miranda continues his series by explaining how such an index is unlike a conventional index.  Read more...
By Additional Articles 2016/06/10 | Source: SimpleTalk | Category: in-memory oltp
Rating: (not yet rated)  Rate this |   Briefcase | 4,126 reads

The Clustered Index is not the Primary Key

As the title says, the clustered index doesn't have to the primary key and vice versa.  Read more...
By Steve Jones 2016/05/24 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 164 reads

Unique Indexes Are Code; Non-Unique Indexes Are Data

Unique indexes are the database developer's responsibility. Non-unique indexes can be more easily maintained directly on the production database by an automated process.  Read more...
By Daniel White 2016/05/06 (first published: 2014/06/26) | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 14,195 reads

NonClustered Index Structure

Learn how the clustered index keys affect the non clustered index structure.  Read more...
By Mayank Shukla 2016/04/11 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 3,570 reads

The DBA's Essential Index Monitoring and Maintenance Tasks

Indexes can be the most critical part of any database. they can drastically improve performance or they can ruin it. Wise management is the key to success.  Read more...
By John F. Tamburo 2018/03/09 (first published: 2016/02/15) | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 6,641 reads

Foreign Key Indexes and Binding

Understand what FK's do and how they use indexes. Then use my script to see if they're using good indexes.  Read more...
By Steve Hood 2016/02/10 | Source: SQLServerCentral.com | Category: foreign keys (fk)
Rating: |  Discuss |   Briefcase | 3,289 reads

Harnessing SQL Server Metadata- Disabling and Rebuilding Indexes

When doing bulk data changes it may be beneficial to disable indexes prior to starting the operation. Fortunately, SQL's rich metadata makes this very easy to automate in a robust fashion.  Read more...
By Joshua Feierman 2018/05/18 (first published: 2015/10/19) | Source: SQLServerCentral.com | Category: maintenance and management
Rating: |  Discuss |   Briefcase | 4,160 reads

How efficient is your covered index?

Observing an index seek utilizing a composite index within SQL execution plan might be more than meets the eye – you should look again.  Read more...
By Simon Liew 2015/10/09 (first published: 2013/08/12) | Source: SQLServerCentral.com | Category: covering index
Rating: |  Discuss |   Briefcase | 14,097 reads

Strange Filtered Index Problem

What I thought was a strange filtered index problem but turned out to be a DB settings problem  Read more...
By Mike Good 2018/05/11 (first published: 2015/08/26) | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 4,441 reads

Indexing Foreign Keys

Foreign Keys are one of the fundamental characteristics of relational databases and enforce the referential integrity. Is it a good idea to index a FK relationship? When can it help?  Read more...
By Alessandro Mortola 2016/09/16 (first published: 2015/06/29) | Source: SQLServerCentral.com | Category: foreign keys (fk)
Rating: |  Discuss |   Briefcase | 13,142 reads

The Importance of Database Indexing

In this article, James Munro demonstrates an example of a simple query without an index and then that same query again with the index. A simple introduction to database indexing.  Read more...
By Additional Articles 2015/06/04 | Source: CodeProject.com | Category: indexing
Rating:  Rate this |   Briefcase | 7,081 reads

The Real World: Rebuilding Index - 1 Instance, 106 Databases

The article show a simple way we managed to schedule index rebuild and reorg for an SQL instance with 106 databases used by one application using a Scheduled job.  Read more...
By Kenneth Igiri 2015/02/17 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 6,189 reads

Grant Fritchey Reviews Minion Reindex

Grant Fritchey reviews Midnight DBA's Minion Reindex, a highly customizable set of scripts that take on the task of rebuilding and reorganizing your indexes.   Read more...
By Grant Fritchey 2015/01/27 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 1,876 reads

Tracking Database DDL Changes with SQLVer

Presents an open-source T-SQL based version tracking system for MSSQL  Read more...
Rating: |  Discuss |   Briefcase | 6,127 reads

Deeper into Nonclustered Indexes: Stairway to SQL Server Indexes Level 2

By this stage, you should be familiar with the basics of SQL Server indexes. We've discussed what an Index actually is, as well as some of the most common types you're likely to encounter. Now that we've seen some simple examples of how Indexes can be useful, we're going to delve deeper into nonclustered indexes, as we'll see how they can improve the performance of more complex queries.  Read more...
By David Durant 2017/10/18 (first published: 2014/11/26) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 28,578 reads

SQL Monitor Custom Metric: Possible Duplicate Indexes

When a table has multiple indexes defined on the same columns, it produces duplicate indexes that waste space and have a negative impact on performance. This metric measures the number of possible duplicate indexes per database above a set threshold. You can then consider dropping the indexes and reverse the change.  Read more...
By Press Release 2014/11/18 | Source: Redgate | Category: indexing
Rating: (not yet rated)  Rate this |   Briefcase | 7,756 reads

An Introduction to SQL Server Indexes: Stairway to SQL Server Indexes Level 1

Indexes are the database objects that enable SQL Server to satisfy each data access request from a client application with the minimum amount of effort, resulting in the maximum performance of individual requests while also reducing the impact of one request upon another. Prerequisites: Familiarity with the following relational database concepts: Table, row, primary key, foreign key  Read more...
By David Durant 2014/11/05 (first published: 2011/02/17) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 57,973 reads

The MidnightDBAs release Minion Reindex

The MidnightDBAs have developed a free reindexing solution to help DBAs perform maintenance on their instances. Read about the solution and attend their webinar.  Read more...
By Press Release 2014/10/24 | Source: SQLServerCentral.com | Category: press release
Rating: |  Discuss |   Briefcase | 1,986 reads

Introducing the Columnstore Index

A brief overview of Columnstore index and its usage with an example  Read more...
By Gayathri Jayaraman 2014/08/07 | Source: SQLServerCentral.com | Category: columnstore index
Rating: |  Discuss |   Briefcase | 7,307 reads

Columnstore Index Changes in SQL Server 2014

SQL Server 2012 introduced columnstore indexes, which can immensely improve the performance of OLAP queries. How were they updated and improved in SQL Server 2014?  Read more...
By Edward Pollack 2014/07/24 | Source: SQLServerCentral.com | Category: columnstore index
Rating: |  Discuss |   Briefcase | 4,817 reads
<< Newer    Items 21 to 40 of 213    Older >>