I'm considering just dropping them and then doing a better job monitoring how quickly they appear. It only became an issue because we consolidated two servers and now Update...

Isn't that only showing the date a statistic was last updated, not when it was last used by the optimizer? The update could be from an auto-update or from...

I thought I would provide an update. Microsoft has turned the case over to product support, as I believe this is a bug. I performed multiple installations involving...

Same results, but it was worth a try 🙂

I just can't reason why it runs fine everywhere else and not here. I'm very tempted to reinstall SQL Server using...

Thank you for the links. I actually found both of those links yesterday, which caused me to think it could be related to some type of imbalance, or possibly...

I'm not concerned with getting the query to run faster, but rather why it runs in under 1 second on non-clustered 2012 servers, and clustered 2008 R2 servers, but over...

Are you referring to this bullet?

Compressed and uncompressed backups cannot co-exist in a media set.

I saw that, but interpreted it as meaning you should not add compressed backups to...

Same edition as the production server, which is Enterprise. The jobs are also identical. I know compression is enabled because I can compress the data to a remote...

Thanks

Agreed. We're not sure why they need OPENROWSET. We imagine it's to avoid a requirement of a linked server, but they also turn on and off xp_cmdshell to...

The security appeared to work fine. I connected to SERVER_A using a SQL account named DBA. I then ran the following statement.

SELECT a.*

FROM OPENROWSET('SQLOLEDB','SERVER_B',

'SELECT *...

Trying it now. Thanks. We're not too familiar with the syntax for OPENROWSET so it make take a while to get it working.

Dave

Here a comment from the link you provided.

When connecting to another data source, SQL Server impersonates the login appropriately for Windows authenticated logins; however, SQL Server cannot impersonate SQL Server...

Anyone???

This is a question I have also asked on a few occasions. I prefer not to look at avg disk queue length because you have to divide that result...