Can you tell us anything else other than the fact that it failed?

Is PowerShell available on both servers?

Is the instance name correct in the PowerShell command?

Is the SQL Agent service...

If it's 6:30 and...

WayneS (1/31/2016)

---

How many Threadizens are going to SQL Saturday Cleveland this upcoming weekend? I'll be flying in Thursday night; I'd love to meet up with you (even better... come on...

WayneS (1/31/2016)

---

GilaMonster (1/30/2016)

---

Oh, hell, yes....

Let me start by saying I don't know PowerShell.

The jobs are defined in msdb, which is some sort of shared storage. When you fail over, the active node picks...

A part of the problem is that you're querying 8M rows on the remote server. This is probably going to take a while. We don't know how wide...

If it runs in a single table scan, then what do you hope to optimize? Since you're reading the entire table because you effective don't have a WHERE clause,...

Orlando is correct, the MD command does create children. The only problem I can see you might run into is if the directory already exists, so you might want...

Are you keeping track of how long it takes to update each one or just letting it run and tracking the overall time for the database? I'm tracking the...

J Livingston SQL (1/31/2016)

---

Jeff Moden (1/31/2016)

---

It is my fault. I was deleting SPAM and hit the wrong thread. I've sent an email to the WebMaster asking if he...

To add one point to what pietlinden said, you can CROSS JOIN more than 2 tables and it generates a row for every possible combination of rows. For example,...

Jonathan AC Roberts (1/31/2016)

---

CAST(LEFT(OMD, 8) as datetime) + 30 < GETDATE();

This is not good practice, I'm not sure it will even work in versions of SQL Server later than...

Well, I'm glad you have it working again.

However, please don't discount the security concerns raised by myself and others. You need to keep control over what logins have sysadmin...

So, Hitesh, I guess the question is about statistics. Do you have a statistics maintenance routine schedule to run regularly? Yes, it can take a long time if...

Thanks for the article, Gail. I learned something new today, which is a good thing every day.