Alan,

In your example the SORT is happening right after the table is read and prior to the Nested Loops join, which makes sense given your example. In my situation...

Here is the SQL and the attached sql plan

DECLARE @SendId INT

SET @SendId = 1

UPDATEEmailTrackingSummary

SETEmailName = tets.EmailName,

SentDate = tets.SentDate,

SendDate = tets.SendDate,

NumberSent = tets.NumberSent,

NumberDelivered = tets.NumberDelivered,

Duplicates = tets.Duplicates,

UniqueClicks = tets.UniqueClicks,

UniqueOpens = tets.UniqueOpens,

HardBounces...

Thanks for the help. Glad to know I don't have to completely tear down the Log Shipping to do the upgrade.

So I have found an error in the SQL Agent Error Logs that is related. "[264] An attempt was made to send an email when not email session has...

Jeff, there is no documentation on what specific query they believed was the cause of the problem.

Grant, thanks for the reminder about the index DMVs.

I appreciate...

Jeff, I have been told that querying such DMV's caused an issue in a production environment and so there is now caution about such queries.

Yes. The PK is clustered. In terms of the summary from BOL, I guess It would be unique in our situation. This is a SQL Cluster...

vsamantha35 (3/9/2015)

---

Hi All,

Looking for some guidance on server migration. We are moving from old h/w to new h/w. i.e. from sql 2008 r2 to sql 2014 RTM. As a result...

Ken Davis (3/2/2015)

---

Imarkum,

Thanks for the reply but if understand the concept, the copy-on-write means a page of data only goes into the snapshot sparse file when that page gets updated...

I think if you simply change the email_level to 0 then you will only be undoing part of what your initial script is doing. The sp_update_job stored proc only...

I don't have 2008R2 disc handy, but I did this on 2012 with no restart of SQL Server.

Ken Davis (2/27/2015)

---

I have a large (1.2TB) database that receives constant inserts but no updates. The inserts can be 100+ per second. Reporting queries against the database can...

vsamantha35 (2/28/2015)

---

Hi All,

How to troubleshoot blocking if u r seeing multiple blocking chains? Do I need to kill all the head blockers?

What is the best approach to deal with...

If you have already configured ssrs on the new instance then it is more challenging. The best thing to do is to install but don't configure ssrs on the...

I would set up a query of the session and request DMVs to run at the same time as your troubled agent job. Capture data every 5 to 15...