szejiekoh (3/29/2016)

---

Grant Fritchey (3/28/2016)

---

If you set up your backups to go to multiple files, you will need those files for the restore. Using multiple files, on multiple drives, is a...

Yeah, Jacob has it nailed. Because it's a calculated column, it's performing the calculation before doing the filtering in the first plan. The second plan, with stored data and no...

I have not done this, but according to this web site[/url], you may not be on the right cumulative update. Make sure you've got that set, then try again.

The default value of the cost threshold for parallelism is very low (5), but 1000 seems excessively high. Depending on the system, I've seen the value moved to somewhere between...

You've gotten some good feedback. I especially like Brad's Checklist. It's very complete.

The one thing you'd really want to focus on, is what is it the company thinks it needs....

If you use powershell, don't get hung up on the naming standard. Just go for the latest date. You can read that property from the files.

You're kind of on the wrong tack.

What's going on is your code is preparing statements and then executing those statements. The prepare itself is a very minor operation (low reads,...

If you set up your backups to go to multiple files, you will need those files for the restore. Using multiple files, on multiple drives, is a mechanism for speeding...

And the execution plan for the update query.

There's no way to simply guess what is happening. You have to gather metrics to understand and the one metric that describes how...

Yep. Sachin has it right. Once the log chain is broken, you have to reset.

Execution plans to understand why this is occurring would be helpful.

Not precisely. It's just a question of running a query against the database or server through a SQL Agent Job. There isn't that much to it. Agent can run independent...

You should be able to do anything with other mechanisms without having to use SSIS. I'm really not aware of anyone who uses SSIS as a monitoring tool. I'll be...

From what I can tell, the statement complete is just the definition of the prepared statement that the sp_execute command is going to run. There are differences between the slow...

I go to hit reply and see Luis has not only answered the question (better than I was going to), but has also raised my biggest concern, it doesn't sound...