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

Articles with tag Indexing Rss

Search for any content tagged indexing

   Items 1 to 20 of 217    Older >>
 

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 2018/06/29 (first published: 2016/02/10) | Source: SQLServerCentral.com | Category: foreign keys (fk)
Rating: |  Discuss |   Briefcase | 4,224 reads

Indexes That Have Not Been Used but Are Being Updated

Greg Larsen talks about how indexes that are not being used are costing you valuable resources and causing your update statements to run longer.  Read more...
By Additional Articles 2018/06/12 | Source: Database Journal | Category: indexing
Rating:  Rate this |   Briefcase | 3,322 reads

NonClustered Index Structure

Learn how the clustered index keys affect the non clustered index structure.  Read more...
By Mayank Shukla 2018/06/01 (first published: 2016/04/11) | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 4,720 reads

Why Are You Dropping and Recreating Your Indexes?

Do you have data load processes that drop indexes to optimize the load process? Are you dropping those indexes in one step, then loading data into your table, only to recreate the indexes in a post data load step?  Read more...
By Additional Articles 2018/05/22 | Source: Database Journal | Category: indexing
Rating:  Rate this |   Briefcase | 4,721 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,377 reads

Covering Indexes: Not Just for SELECT but also for UPDATE statements

Covering indexes help UPDATE performance also  Read more...
By Mike Byrd 2018/05/15 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 1,270 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,502 reads

Missing Index Impact and Join Type

Erik Darling shows how missing index requests have different impact numbers depending on the query's join type.  Read more...
By Additional Articles 2018/04/26 | Source: Brent Ozar Unlimited Blog | Category: indexing
Rating: (not yet rated)  Rate this |   Briefcase | 6,675 reads

Interviews: Covering index

A few notes on how to prepare for an interview with indexing questions.  Read more...
By Steve Jones 2018/03/21 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 88 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,914 reads

When Does Index Size Change Index Choice?

Erik purposely fragments indexes trying to slow down queries.  Read more...
By Additional Articles 2018/02/15 | Source: Brent Ozar Unlimited Blog | Category: indexing
Rating: (not yet rated)  Rate this |   Briefcase | 3,323 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,617 reads

Indexing for Windowing Functions: WHERE vs. OVER

Erik Darling shows that if you take SQL Server's word when it asks for an index, things can go horribly awry.  Read more...
By Additional Articles 2017/10/09 | Source: Brent Ozar Unlimited Blog | Category: indexing
Rating: (not yet rated)  Rate this |   Briefcase | 3,826 reads

How to Drop All Your Indexes – Fast

You probably shouldn't be doing this, but if you need to, Brent Ozar has a script for that.  Read more...
By Additional Articles 2017/09/18 | Source: Brent Ozar Unlimited Blog | Category: drop indexes
Rating: (not yet rated)  Rate this |   Briefcase | 4,597 reads

Comparing Space Usage for Different Compression Types

This is an investigation, to get an impression on the impact of the used disk space before and after compression considering different index types.  Read more...
By Michael Salzmann 2017/03/23 | Source: SQLServerCentral.com | Category: compression
Rating: |  Discuss |   Briefcase | 749 reads

One way to get an index seek for a leading %wildcard

In an effort to make leading wildcard searches sargable, Aaron Bertrand plays around with a trigram-type implementation in SQL Server.  Read more...
By Additional Articles 2017/02/28 | Source: SQLPerformance.com | Category: indexing
Rating:  Rate this |   Briefcase | 5,610 reads

Internal Query Processor Error with ColumnStore Indexes

SQL Server 2016 does not allow computed columns to co exist with columnstore indexes and clustered btree indexes on same table.  Read more...
By Mala Mahadevan 2016/12/29 | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 662 reads

Which Indexes are not Used?

During the development cycle, indexes will be placed on SQL Server tables to speed up performance when searching for records. Lots of thought probably has gone into creating just the right mix of indexes based on how developers think customers will use the system. But how do you tell if all the indexes are being used once your database has been implemented into production?  Read more...
By Additional Articles 2016/12/19 | Source: Database Journal | Category: indexing
Rating: (not yet rated)  Rate this |   Briefcase | 8,176 reads

Can I Use Statistics to Design Indexes?

"I’ve noticed that many indexes in my data warehouse aren’t used frequently. Is there a way to use the automatically generated statistics to make useful indexes?" Kendra Little answers the question in episode 18 of Dear SQL DBA.  Read more...
By Additional Articles 2016/11/15 | Category: statistics
Rating:  Rate this |   Briefcase | 4,586 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
   Items 1 to 20 of 217    Older >>