Ran the Windows Update Troubleshooter: http://go.microsoft.com/?linkid=9830262

It found 2 issues and fixed those issues automatically, one of which was:

0x80070005 -2147024891 ERROR_ACCESS_DENIED The authentication method is not supported. -...

SFC.exe /verifyonly came back with no corrupt system files.

Great suggestion, thanks for the link. I have checked for WMI corruption using the steps in the link and everything checks out fine.

Below are a few scenarios/errors that indicate...

GilaMonster (6/8/2009)

---

Recovery pending means that for some reason SQL cannot run restart recovery on the database. Usually this is because the log is missing or corrupt.

Do these files exist? Is...

This could be accomplished by logging error output to a new table and adding logic to not send new emails for x number of hours from last notification. I...

Are these not read-only tables in the Resource database? http://blog.sqlauthority.com/2008/07/27/sql-server-mssqlsystemresource-resource-database/

I normally use SQL Admin Toolset by Idera to change fill factors. System databases are not analyzed with this tool. So script out all the indexes in msdb...

The accidental DBA before me had they server level default fill factor setting at 20. I have fixed all fill factors in user databases but am getting results in...

Answer to my own question is "no DDL actions allowed using a linked server". I worked my way around it by adding a sproc in the master database in...

Fantastic videos on YouTube, just search "learn sql".

One thing that just hit me is that I am attempting to pull the xp_readerrorlog data across the linked server. Would I encounter the distributed transaction error if I...

ChrisM@Work (2/18/2015)

---

In the t4 part of the query, there are significant differences between actual and estimated number of rows / number of executions, indicating that statistics may be wildly out...

Note back from the developer:

I found that there were two objects created identical. 1st was used to query and filter the data and the 2nd was being used to update....

Matched the column names to the original stuck query and added friendly alias'. Results pull matching data in both test and prod (fresh data). My hope is the...

This filter AND O.CompanyClientMemberID IS NOT NULL won't work in the join, if the filter must be active then it must be in the WHERE clause. I'd mark it as...