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

Content with tags Blogs, Indexing Rss

   Items 1 to 8 of 8   
 

DTA and Hypothetical Indexes

For those of you that don’t know DTA stands for Database Engine Tuning Adviser and is available from the Tools...  Read more...
By Chris McGowan 2013/05/15 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,852 reads

Hunt Down Tables Without Clustered Indexes

This one's a gimme, but an underrated utility script when I enter a new environment and look for low-hanging fruit...  Read more...
By William Assaf 2013/05/09 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,639 reads

SQL Server : Part 10: Importance of Key Column Position While Creating Index

Now we have discussed about different types of indexes in the last posts. In this post, let us discuss about...  Read more...
By nelsonaloor 2013/04/22 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 3,055 reads

Index Analysis: The Re-Return

A couple years back, I wrote a few blog posts about an indexing script that I use with clients from...  Read more...
By StrateSQL 2012/12/25 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,230 reads

Rebuild index with "Alter Index Rebuild" or "DBCC DBREINDEX"

You can rebuild all index for a table with "Alter Index Rebuild" and "DBCC DBREINDEX" . First, in BOL, for "DBCC...  Read more...
By 2012/06/27 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 6,178 reads

SQL Server Index Tuning for Mere Mortals

One of the most important things to measure, monitor, and “get right” for good overall SQL Server OLTP performance is...  Read more...
By GlennBerry 2011/01/11 | Source: SQLServerCentral.com | Category: blogs
Rating:  Rate this |   Briefcase | 2,231 reads

Can You Dig It? – Missing Indexes

She can dig it! D Sharon PruittWhen I started using XQuery to dig into the plan cache, it was just searching...  Read more...
By StrateSQL 2010/12/20 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 1,462 reads

Which is Better: Heaps or Tables with Clustered Indexes?

I have always been of the personal opinion that all SQL Server tables have a clustered index. As part of the research I am doing on a new book on High Performance Index Maintenance , and on heaps specifically, I ran across this SQL Server Best Practices...   Read more...
By Brad McGehee 2009/02/20 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 4,240 reads
   Items 1 to 8 of 8   
 
Tags
administration (1)    
dmv queries (1)    
dta (1)