Right there with you. If it's not acknowledging the URL as a name, it's likely an error.

Reading through "all" the documentation, the suggestion is that the URL should just work. I guess the question would be is the distribution server up to the same service pack...

Availability Groups require the clustering service to be running, but they don't require an actual failover cluster to be created. So no shared storage is required. Just the service that...

It depends on what the target of the session was. If you output it to a file, then that file should be there. And yes, you should be able to...

Are the databases online? Do they pass a consistency check? Those are my primary concerns.

RECOMPILE might not be the right hint to use here. If a local variable is used and performance is better than when a parameter is used, then the problem is...

Hmmm.... yeah, you'd think. As I say, I haven't tried setting that up, so I don't have a good suggestion. What is the error message that you get? Be sure...

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...