Kevin and Jeff: Thank you both for the time you have spent on this thread.

I did find 165 indexes that had the NO_RECOMPUTE option on the stats....

TheSQLGuru (8/5/2016)

---

Jeff Moden (8/5/2016)

---

lmarkum (8/5/2016)

---

Jeff Moden (8/5/2016)

---

lmarkum (8/5/2016)

---

I forgot to mention that in these plans there will be a missing index recommendation on the NewsletterHistory. I don't understand the...

Jeff Moden (8/5/2016)

---

lmarkum (8/5/2016)

---

Jeff Moden (8/5/2016)

---

lmarkum (8/5/2016)

---

I forgot to mention that in these plans there will be a missing index recommendation on the NewsletterHistory. I don't understand the recommendation...

I am using Ola Hallengren to handle the index and stats maintenance.

Jeff Moden (8/5/2016)

---

lmarkum (8/5/2016)

---

I forgot to mention that in these plans there will be a missing index recommendation on the NewsletterHistory. I don't understand the recommendation because the only...

Thanks for the feedback. Here is an actual plan. One thing I also see in the proc is filtering in a WHERE clause based on strings instead of...

I forgot to mention that in these plans there will be a missing index recommendation on the NewsletterHistory. I don't understand the recommendation because the only place I can...

I have attached the most often used plan prior to 8/1. There are three new plans that show up on 8/1. I attached the one I previously spoke...

There are a number of different query plans beginning on 7/1. Viewing in SQL Sentry Plan Explorer I can see where the increase in rows is coming from fairly easily,...

Thanks for the time to provide responses that helped me learn something about this situation. Much appreciated.

The database is in Simple recovery and we keep one full backup at a time. Looks like based on the below I would be out of luck because my...

Everything is in sync. I can tell that from the Log Shipping Report in the Performance Dashboard Reports. I did run your queries, which show essentially the same...

I had a tried using that column from sys.dm_exec_requests and some math, but it kept telling me that the estimated completion time was the current moment. I learned a...

About to add a second transaction log file. Transaction logs already run every 5 minutes. Sounds like though maybe I should consider killing it, but wonder then...

Jeff Moden (3/13/2016)

---

Not sure I can help with the final outcome but here are a couple of problems that you're having...

1. Dropping the clustered index isn't simple. It...