I suspect that's a good part of the problem. If I had to guess, lots of TempDB usage and TempDB still...

🙂 I'll take a look a bit later if I find the time.

Now that I think of it, I didn't specify fullscan....

Why?

Have you tested that and seen that forcing a hash...

Lynn Pettis (4/8/2013)

---

2) Actual execution plan as a .sqlplan file, not XML plans you included in the...

See the article in Craig's sig. Describes how...

I might be able to explain, if I knew which table the '4th table' was. 😉

Is that the actual plan from before the stats update or after?

Lynn Pettis (4/12/2013)

---

True, Gail, but apparently it is required that a...

There's absolutely no need to use temp tables in that, doing so just adds complexity and reduces the performance.

There is, but to be honest you shouldn't be using nolock everywhere. It's not a go-faster switch, it is not a performance tuning technique, it is not necessary to make...

Or open the error log in notepad.

Network service is OK for SQL Agent, providing it doesn't need more permissions than network servce grants.

Double check, is it absolutely, certainly, definitely not running as your account? Double check...

Try updating stats with full scan and then the query with the getdates again.

To diagnose the problem, I really need to see the actual plan of that query.

What is the SQL Server agent service account?

Please post table definitions, sample data and desired output. Read this to see the best way to post this to get quick responses.

http://www.sqlservercentral.com/articles/Best+Practices/61537/

sqlfriends (4/11/2013)

---

My question is if one of the backup for example full backup is using compression backup, the transaction log or diff is using non- compressed, can the restore be...