SQLServerCentral.com Content tagged Blogs, Indexing

DTA and Hypothetical Indexes

Wed, 15 May 2013 06:00:00 UT

For those of you that don’t know DTA stands for Database Engine Tuning Adviser and is available from the Tools...

Hunt Down Tables Without Clustered Indexes

Thu, 09 May 2013 06:00:00 UT

This one's a gimme, but an underrated utility script when I enter a new environment and look for low-hanging fruit...

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

Mon, 22 Apr 2013 06:00:00 UT

Now we have discussed about different types of indexes in the last posts. In this post, let us discuss about...

Index Analysis: The Re-Return

Tue, 25 Dec 2012 07:00:00 UT

A couple years back, I wrote a few blog posts about an indexing script that I use with clients from...

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

Wed, 27 Jun 2012 06:00:00 UT

You can rebuild all index for a table with "Alter Index Rebuild" and "DBCC DBREINDEX" . First, in BOL, for "DBCC...

SQL Server Index Tuning for Mere Mortals

Tue, 11 Jan 2011 07:00:00 UT

One of the most important things to measure, monitor, and “get right” for good overall SQL Server OLTP performance is...

Can You Dig It? – Missing Indexes

Mon, 20 Dec 2010 07:00:00 UT

She can dig it! D Sharon PruittWhen I started using XQuery to dig into the plan cache, it was just searching...

Which is Better: Heaps or Tables with Clustered Indexes?

Fri, 20 Feb 2009 07:00:00 UT

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...

Database source control in just 5 minutes
It takes just 5 minutes to connect your SQL databases to source control. Got 5 minutes to spare? Get started now.