Click here to monitor SSC
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 189    Older >>
 

Reduce Time for SQL Server Index Rebuilds and Update Statistics

This tip will explore two features to speed up SQL Server index and statistics maintenance in the SQL Server Enterprise, Standard and Express editions.  Read more...
By Additional Articles 2014/01/31 | Source: MSSQLTips.com | Category: indexing
Rating:  Rate this |   Briefcase | 4,858 reads

Free eBook: 45 Database Performance Tips for Developers

As a developer, if you need to go into the database and write queries, design tables, or determine the configuration of your SQL Server Systems, these tips should help make sure you're not unnecessarily sacrificing database performance. This eBook has 45 easy tips to improve the performance of your indexes and T-SQL queries, and hunt down problems within ORM tools and database design.   Read more...
By Press Release 2014/01/02 (first published: 2013/11/04) | Source: Redgate | Category: tips
Rating:  Rate this |   Briefcase | 16,330 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 | 19,431 reads

SQL Server Index Properties in Management Studio

Understanding indexes and how they work can be complicated enough for a Jr. DBA, but throw in all the different options and properties and an index can soon be overwhelming. Brady Upton takes an introductory look at creating an index in SQL Server using SQL Server Management Studio. He explains what each index property is meant for and the various options presented.  Read more...
By Additional Articles 2013/11/19 | Source: MSSQLTips.com | Category: create index
Rating:  Rate this |   Briefcase | 4,163 reads

Using Indexes to Reduce Blocking in Concurrent Transactions

New author Nilav Ghosh brings us a performance tuning article to help your queries run better. This article examines how indexes can help reduce blocking.  Read more...
By Nilav Baran Ghosh 2013/11/15 (first published: 2009/07/07) | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 18,224 reads

Overview of the Different In-Memory OLTP Index Types

In-Memory table or what Microsoft refers to as In-Memory OLTP, or Hekaton is a new type of table is available with SQL Server 2014. In this article Greg Larsen discusses the different types of indexes you can place on your In-Memory tables, and how those indexes support different search criteria.  Read more...
By Additional Articles 2013/11/13 | Source: Database Journal | Category: in-memory oltp
Rating: (not yet rated)  Rate this |   Briefcase | 2,445 reads

Free eBook: 45 Database Performance Tips for Developers

As a developer, if you need to go into the database and write queries, design tables, or determine the configuration of your SQL Server Systems, these tips should help make sure you're not unnecessarily sacrificing database performance. This eBook has 45 easy tips to improve the performance of your indexes and T-SQL queries, and hunt down problems within ORM tools and database design.   Read more...
By Press Release 2014/01/02 (first published: 2013/11/04) | Source: Redgate | Category: tips
Rating:  Rate this |   Briefcase | 16,330 reads

Implementing, loading and optimizing a Type 2 Slowly Changing Fact Table

This article shows how to implement a Slowly Changing Facts Table, how to overcome the problems encountered when using the MERGE statement to process the data and suggest a minimal set of indexes to aid data loading and quering.   Read more...
Rating: |  Discuss |   Briefcase | 5,622 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,018 reads

Tables and Clustered Indexes Part 2

A table does not so much 'have' a clustered index as a table 'is' a clustered index.  Read more...
By Hakim Ali 2013/07/22 | Source: SQLServerCentral.com | Category: clustered index
Rating: |  Discuss |   Briefcase | 6,410 reads

SQL Server: How Important Are Index Statistics

In this article Greg Larsen will show you how to identify when your index statistics were updated last, what method was used to gather statistics, and how to update your statistics.  Read more...
By Additional Articles 2013/07/11 | Source: Database Journal | Category: indexing
Rating: (not yet rated)  Rate this |   Briefcase | 2,917 reads

Column Order in an Index

This short article shows the importance of order of columns in an index.  Read more...
By Sarvesh Singh 2013/07/05 (first published: 2010/11/23) | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 20,600 reads

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

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 | 56,628 reads

HASHBYTES: Is CHECKSUM really required?

When compared with HASHBYTES, CHECKSUM, has a number of drawbacks. Hence, a question that comes up is: Is Checksum really required? In this article, I attempt to answer that question.  Read more...
By Nakul Vachhrajani 2013/03/27 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 6,857 reads

Precision Indexing: Basics of Selective XML Indexes in SQL Server 2012

Seldom has a SQL Server Service pack had such an effect on database development as when SQL Server 2012 SP1 introduced selective XML indexes. These transform the practicality of querying large amounts of XML data. Seth Delconte demonstrates how and why this feature makes all the difference.   Read more...
By Additional Articles 2013/02/06 | Source: SimpleTalk | Category: indexing
Rating: (not yet rated)  Rate this |   Briefcase | 2,196 reads

SQL Server Performance Tuning – Index Tuning

In earlier installments of this series we looked at T-SQL Performance optimizations along with different T-SQL practices, we can now turn our attention to the second part of this series which is index Tuning  Read more...
By Additional Articles 2013/01/30 | Source: SQL Server Performance | Category: indexing
Rating:  Rate this |   Briefcase | 4,863 reads

Stairway to SQL Server Indexes: Level 3, Clustered Indexes

Now that we've seen the basics of indexing, and taken a deeper dive into Nonclustered Indexes, this Level will focus on searching the table, which will, in turn, will lead us to a discussion of clustered indexes.  Read more...
By David Durant 2013/01/25 (first published: 2011/06/22) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 26,066 reads

Hypothetical Indexes on SQL Server

Sometimes, you have to test out alternative indexing strategies, but the task of creating the candidate indexes would just take too long. Is there another way? Well, yes, why not use the same method the DTA (Database Tuning Advisor) uses, and take the tedium out of the job.  Read more...
By Additional Articles 2013/01/22 | Source: SimpleTalk | Category: indexing
Rating:  Rate this |   Briefcase | 3,239 reads

Index Create Memory Setting for SQL Server

The "index create memory" option in sp_configure advance server settings, controls the maximum amount of memory initially allocated for creating indexes. This tip deals with common issues around this setting.  Read more...
By Additional Articles 2012/12/28 | Source: MSSQLTips.com | Category: indexing
Rating:  Rate this |   Briefcase | 3,097 reads

Review Your Indexing

Today Steve Jones reminds us that we should analyze and re-evalute our indexing strategy on a regular basis.  Read more...
By Steve Jones 2012/11/26 | Source: SQLServerCentral.com | Category: editorial
Rating: (not yet rated) |  Discuss |   Briefcase | 282 reads
<< Newer    Items 21 to 40 of 189    Older >>