Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag index Rss

   Items 1 to 10 of 10   
 

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: Red-Gate | Category: index
Rating: (not yet rated)  Rate this |   Briefcase | 4,922 reads

Index Breakdown

Provides a robust breakdown of all indexes contained within a database allowing for quick analysis and identification of inefficient, redundant, unused, bloated, stale, and / or poorly architected indexes.  Read more...
By Sean Smith 2014/10/30 | Source: SQLServerCentral.com | Category: index
Rating: |  Discuss |   Briefcase | 3,942 reads

Index Breakdown

Provides a robust breakdown of all indexes contained within a database allowing for quick analysis and identification of inefficient, redundant, unused, bloated, stale, and / or poorly architected indexes.  Read more...
By Sean Smith 2014/10/30 | Source: SQLServerCentral.com | Category: index
Rating: |  Discuss |   Briefcase | 3,942 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: Red-Gate | Category: tips
Rating:  Rate this |   Briefcase | 15,645 reads

Index Breakdown

Provides a robust breakdown of all indexes contained within a database allowing for quick analysis and identification of inefficient, redundant, unused, bloated, stale, and / or poorly architected indexes.  Read more...
By Sean Smith 2014/10/30 | Source: SQLServerCentral.com | Category: index
Rating: |  Discuss |   Briefcase | 3,942 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 | 3,896 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,231 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: Red-Gate | Category: tips
Rating:  Rate this |   Briefcase | 15,645 reads

Unique Identifier as Clustered index

This script selects clustered indexes containing only a uniqueidentifier column  Read more...
By Wilfred van Dijk 2013/10/17 | Source: SQLServerCentral.com | Category: index
Rating: |  Discuss |   Briefcase | 1,124 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,358 reads
   Items 1 to 10 of 10   
 
Tags
breakdown (1)    
clustered index (1)    
create index (1)    
custom metrics (1)    
database design (1)    
database development (1)    
database performance (1)    
details (1)    
duplicates (1)    
heap (1)    
hekaton (1)    
in-memory oltp (1)    
management studio (ssms) (1)    
non-clustered index (1)    
optimize (1)    
orm (1)    
performance (1)    
scans (1)    
seeks (1)    
size (1)    
sql monitor (1)    
stats (1)    
tips (1)    
troubleshoot (1)    
t-sql (1)    
tuning (1)    
unique identifier (1)    
unused (1)    
usage (1)