I've tried running repair and everything else I can think of. It is a non production instance that can be rebuilt and will be phased out at some point. ...

Thanks for the responses. I'll check into opening a case. Microsoft support is very expensive isn't it?

Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64)

Oct 19 2012 13:38:57

Copyright (c) Microsoft Corporation

Enterprise Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)

It shows 11.0.3000...

I guess now that I think about it, the clustered index might be greatly speeding up the updates so just comparing reads to writes isn't a good way to determine...

The one with 0 reads is not unique.

I'm...

I assumed if the writes were significantly more than reads than the index is bad. If the clustered index has very few reads then doesn't that mean that the table...

Steve,

Thanks for sharing that article with me. She has good insight that I can learn from.

Thanks Erin. I try to break them down to understand them too.

Many times the scripts are to alter some stored procedure or view so there is no execution plan...

Thanks.

They instances are listed there but SQL Server install does not see either one. I'm just going to go a clean install then move the databases into the new...

Still stuck on this one. How does the SQL Server installer detect existing instances to add features? How can I get analysis services added to an existing instance...

Thanks for responding John. There is no blocking going on. If I try to run index maintenance on an index that belongs to a table in the long-running select query,...

Thanks much. What could I provide that would be useful? The XML of the execution plan? Product has been discontinued and the vendor is no longer actively supporting it...

Mainly I am interested in understanding why a select query would stay open and running for almost an entire week. CPU use rarely if ever goes above 5 to 10%....

Adding the plan guide for that one query has changed the hit rate from 60% to 99%.

I don't know if it made a performance difference though because the query plan...

Hi everyone. I added a plan guide.

DECLARE @stmt nvarchar(max);

DECLARE @params nvarchar(max);

EXEC sp_get_query_template

N'SELECT * FROM dbo.REFER WHERE USERID = 619 AND MSGID =...