Jeff Moden (12/30/2016)

---

@lmarkum,

There are a couple of issues that are just wasting a lot of CPU time.

The first is the problem of the store procedure variables that involve dates being...

TheSQLGuru (12/28/2016)

---

Sorry to tell you this, but that code is just horrible.

1) Why is it passing in datetime values as varchars?? You simply MUST make ALL of those datetimes datatypes....

Here is the estimated SQL Plan for the INSERTUPDATE proc that is deadlocking. This is the plan I get when I pass into it a TrackingNumber that does not...

TheSQLGuru (12/23/2016)

---

1) BLOCKING is a normal part of transactional processing in SQL Server. It is not something that can be avoided. LONG-TERM blocking is another issue, and is often the...

Eddie Wuerch (11/29/2016)

---

1. Index ID #7 is a non-clustered index. It contains copies of table data (the...

It shows "Sent."

Thanks Chris.

The query against sysmail_allitems returns the test email I sent myself and it shows the two attempts to generate an email from a failed SQL Agent job I...

I found the below in the Windows Application Log.

Service cannot be started. Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. ---> System.Xml.XmlException: The 'SemanticQuery' start tag on line...

We have SQL Diagnostic Manager monitoring this instance. When I see a spike in disk reads and disk writes per second then avg disk queue length spikes as well....

This is a data warehouse SQL Server instance and there is a nightly job that runs at 9 pm. Part of what it does is restore several databases, one of...

Sue_H (8/17/2016)

---

The error is thrown by the named pipes provider. Are the same protocols enabled on all the clients in the scenarios?

The order also matters. On the client computers,...

I asked for this to be posted so let me explain more.

If an RDP connection is made to the server hosting the SQL instance then we get the error mentioned....

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...

TheSQLGuru (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 because...

TheSQLGuru (8/6/2016)

---

lmarkum (8/5/2016)

---

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...