Some of these were introduced in SQL Server 2008 R2, but were included...

lauri.pietarinen (6/26/2014)

---

May I suggest an alternative script for the same purpose? It takes into consideration ascending/descending but gives false positives for "mirror image" indexes, e.g.

(c1 , c2 desc, c3) can...

Sean Lange (6/19/2014)

---

Ed Pollack (6/19/2014)

There's a bunch of fun ways to do this and in thios one case I went explicitly for the shortest, quickest, and dirtiest 🙂 Not...

Sean Lange (6/19/2014)

---

Ed Pollack (6/19/2014)

---

raghava_tg (6/18/2014)

---

create table #temp (id int, data varchar(80))

insert into #temp (id, data)

select 1, 'a,b,c'

union all

select 2, 'x,y'

union all

select 3,'j,k,l'

select * from #temp

i want to create...

raghava_tg (6/18/2014)

---

create table #temp (id int, data varchar(80))

insert into #temp (id, data)

select 1, 'a,b,c'

union all

select 2, 'x,y'

union all

select 3,'j,k,l'

select * from #temp

i want to create a output like this.

1...

I have a recent SSC article on linking up rows of data to grab a previous or next value for a given column that may be of help:

http://qa.sqlservercentral.com/articles/CTE/109287/

This has methods...

kris7233 (6/17/2014)

---

Great article, and very helpful for me especially right now at work.

I'm wondering why you dropped

NCI_Product_Weight_DUPE and

NCI_Product_Weight_OVERLAP

Instead of dropping

NCI_Product_Weight and

NCI_Product_Weight_DUPE

Just leaving...

DennisPost (6/17/2014)

---

Great article!

This helped me find a bunch of overlapping indexes.

Besides the is_Disabled flag, I'd also include the has_filter flag and filter_definition as well.

Most of the duplicates I found had...

alexander.oss (6/16/2014)

---

I've seen some duplicate-looking indexes created intentionally (perhaps) because the creator wanted to make use of an index that covered common queries. So be careful of deleting duplicates...

That's an understandable question---and I intentionally left out any automatic scripting from the article. Adding and removing indexes is delicate work and should be done carefully with quite a...

The is_disabled flag could be worked in, but I would venture that a disabled index and an enabled index that are identical should be flagged as dupes.

For just display purposes...

Both are good points! In my effort to keep this "simple" I left out a few use-cases, which you both have covered. I'll modify the article shortly to...

I'll take this one---will go through the changes to columnstore indexes in SQL Server 2014 and an example of the performance benefit of using one vs. standard indexes.

Thanks!!

So far so good w/ our SQL Saturday---I've got a bunch of great volunteers that...

Good question! sp_updatestats will run an UPDATE STATISTICS statement on all statistics in the database. This will...