Huh, so doing that via command-line syntax is possible! Guess I slipped up on that one :-P. I seem to recall trying to do something similar via cmdshell...

Ah, you'll probably need to create an Agent job and specify it as a Powershell type. Using xp_cmdshell may work, but it doesn't have the flexibility of Powershell. ...

Hm. I could be wrong on this, but I believe xp_delete_file will only work on SQL Server backup and report files; that is, files ending in .trn, .bak, and...

Hm. I believe something like this should work:

SELECT CASE_ID, MAX(DATE) as [MY_DATE],FIELDA,FIELDB

INTO #Temp

FROM dbo.DB2 WHERE FIELDA = 1 AND FIELDB IS NULL GROUP BY CASE_ID,FIELDA,FIELDB)

SELECT Maxdate.Date,db1.CASEID

FROM db1

WHERE...

At my last job, I got a grand 2 days of vacation time a year, and everyone got Thanksgiving Day and Christmas Day off; that was it. I was...

Hm. Without table definitions and a bit of sample data, it's hard to make an exact suggestion, though I can see the problem you're having; you're using MAX(SFEffectiveDte), but...

Hm. From what I can tell, you're trying to search for something LIKE '_%', correct? That is, you want to search for things where there's an underscore, then...

Ah, looks like we're back to where we were when the problem started; things are moving pretty slowly again. It seemed that the max memory adjustment helped, but it...

Huh, wasn't aware of the OS memory limit. That would definitely explain the usage amount, though; we're on Standard edition. The actual physical box we're on has 98GB...

Huh, interesting! Since you mentioned the server memory settings, I took a look again. For whatever reason, the max memory usage was dropped from 28GB to 24GB. ...

Well, I was able to talk with one of the sysadmins this morning, and I got a look at the VM specs. The new physical box it's on has...

So far, we haven't found a resolution. I've been able to isolate the problem to the CPU, but I'm not certain why the CPU would be more strained now...

Hrm... I might be missing something here, but why is the second case incorrect? September this year had 30 days, so the difference between 22 after midnight and...

Barring any missing criteria, this should be an UPDATE...FROM query:

UPDATE Destination

SET Destination.d = Source.a

FROM Destination

INNER JOIN Source

ON Destination.e = Source.b

Test this first, of course, before firing it off as an...

Admittedly, I haven't looked at the VM setup much at all; I don't have much sway in that area, so I'm more or less blocked from examining the VM itself...