This one you can solve for...

If you don't update statistics manually you could wind up with some very different query plans (both for the better and perhaps worse) when you switch this on. However, the...

1) you asked to not be lectured on GUIDs, so I won't do that.

2) I WILL lecture you on the design choice of doing a partial insert and then updating...

Luis Cazares (7/6/2016)

---

You're over complicating yourself. Here's a simpler version of your query.

SELECT l.pageno,

l.batchid,

l.loadid,

n AS lnidmin,

...

See if the attached will get you started.

Indianrock (7/5/2016)

---

We have a project to move our largest customer database, and tempdb, from Netapp magnetic drives to Netapp SSDs.

I hadn't heard of using these for anything other than tempdb??

This...

ffarouqi (7/5/2016)

---

Grant Fritchey (7/5/2016)

---

I'd want the specifics on the error message.

If it's getting timed out, that means it's firing, so it's not an issue that it's an Agent job,...

Download a copy of Glenn Berry's SQL Server Diagnostic Scripts for your version of SQL Server. An AMAZING collection of free stuff there!

What does the error details for the job say? Perhaps modify the job to add step details to the logging process. Have someone stay up and monitor the server(s) involved...

sp_whoisactive has an option to show you the executing query plan. It is a MARVELOUS FREE tool you really should read up on. SQLBlog.com has a 30-day series on it...

Use sp_whoisactive to determine how much work has been done, query plan, tempdb usage, blocking, etc. You can also run it in differential mode and see how much work is...

If the structure of the temp table is fixed I always declare it outside the dynamic sql simply because then if I need to use it outside I know it...

It is very easy to adjust MAXDOP to suit varying load times since it is a live/immediate setting and requires no reboot. I am tired and can't recall it's affect...

Please don't double-post.

Answer here: http://www.sqlservercentral.com/Forums/Topic1799126-392-1.aspx

MMITTAL 758 (7/1/2016)

---

Hi All,

I want to have the distinct values for the column which is satisfied in the case statement and also want to get the condition satisfied for the...