+1

Luis Cazares (3/24/2015)

---

This is a quick idea.

WITH Letters AS(

SELECT TOP 26 CHAR(ROW_NUMBER() OVER(ORDER BY (SELECT NULL)) + 64) letter

FROM sys.all_columns

)

SELECT DISTINCT n.*...

SQL_Surfer (3/24/2015)

---

If I embed the sql inside a proc, it takes over an hour but if i just run as is, it executes in less than 10 seconds. I don't...

I used to use the DTA back some years back but, for me, have gotten more bang for my buck by running DMV queries to find my longest running queries...

ZZartin (3/24/2015)

---

Based on what you have posted, these indexes are not helping you in any way. Indexes speed up reads and slow down modifications. In other words an index, when...

MadAdmin (3/24/2015)

---

19 indexes? Epic!

In addition to TheSqlGuru's great advice,

before you drop indexes, take note that there are some heroes who do silly things like drop and create indexes in SSIS...

... and since this is such an important topic I thought I'd do quick test to demonstrate.

For the first test we'll INSERT 500,000 rows into a table without an...

Sapen (3/24/2015)

---

Alan.B (3/23/2015)

---

Although the user seeks, user scans and userlookups are all 0 the user updates is definitely a lot. I am thinking to speed up updates on subscriber these...

I used a temp variable in my solution below for sample data so that you can just run this in SSMS. The SELECT statement is what you're looking for.

DECLARE...

The problem is that the @TABLE_STYLE variable is a fed to an inline style which means the style can't include style tags. E.g. "style = {Font-family: arial; color: red}"

A style...

My apologies - I misread you original post a little. I was under the impression that some of these indexes were 10% fragmented weekly, not more than 10% as you...

I just had an external Vendor call and mention they want to change the Fill Factor setting for a server.

In my experience it's better to leave the the server setting...

Although the user seeks, user scans and userlookups are all 0 the user updates is definitely a lot. I am thinking to speed up updates on subscriber these indexes are...

Blog is down :crying:

Forgive me if I'm wrong (it's been a while and I'm going by memory here). You can go to Start > Run (or Windows key + R in windows 8+)...