I appreciate the answers for the CASE statement and will test them when I can later tonight. I borrowed this code from the internet and just never cleaned it...

David,

Maybe I missed it in your script but I don't see where you have set up a Distribution database.

So the query below from another forum clued me in to the problem. I had mistyped the database name in my restore script when I restored it to another...

I am getting this same error. My situation might be different from the person who originally posted. Not sure. I restored a database from one SQL instance...

Justin Manning SA (7/27/2015)

---

Apart from the network issue, which needs to be investigated, how big is the log file and what are the VLF counts on it?

This would also...

Jeff Moden (7/26/2015)

---

There are several things that pop into my mind.

1. If the database backup isn't a compressed backup, then you have some serious file size and freespace issues...

I have used a 2005 Publisher with a 2012 Subscriber. I think if you want to try a mix of SQL versions you should try it in a test...

Jeff, Thanks for your time on the forum and with my question. Just the feedback I am looking for to either confirm I am thinking correctly or steer me...

Jeff,

This table does not have any unique indexes. The tables that have a unique non-clustered are few and far between. The table is not partitioned, and neither are...

Jeff, I completely agree that re-writing code is important and it is good to be reminded of the importance of re-writing code. Much of the code I see...

Jeff, as I identify long running queries I come across tables with too many indexes. I examine the usage of those indexes with the usage_stats DMV and find that...

Alan,

We were talking about two differenet things. I was talking about reads and writes against indexes, which is shown is the usage stats DMV and not SET STATISTICS IO...

Alan,

Thanks for the comments. If an index has 50 reads and 1 million writes, for example, then 99.9 of the usage of that index is spent on maintenence....

I see the same issue occcuring with a lot of the primary keys as well. Would the concensus be the same there too?

Thanks for the comments and help. The number of reads on some of these did give me pause, despite the out of balance ratio to writes. I think...