It really depends on what you're looking for. For example, Red Gate SQL Backup goes above and beyond the CMS when dealing with backups across multiple servers, especially in how...

I've installed it three times without...

This is such a subjective question. And there are tons and tons of recommendations out there if you search for them. My favorites:

Red Gate SQL Monitor

[/url]

and SQL Sentry

For specialized performance...

garry.lovesey (8/19/2014)

---

Hi Grant, thank you for your input. I have sent off an e-mail asking the supplier if they really need the COLLATE statements in there.

Do I need the MERGE...

I'm not sure why they have COLLATE statements in the WHERE clause, but it's unlikely to help the code.

Keep an eye on all those variables and parameters too for bad...

Not without error messages or something that indicates what's going wrong on your end, no.

dstoltz 35443 (8/18/2014)

---

The 4 hour response time I mentioned was actually for the hardware support to respond with new hardware if needed, to get the server operational. Restore times/recovery would...

dstoltz 35443 (8/18/2014)

---

Thanks everyone - unfortunately, we don't have a DR site, or even a DR server...we have a 4 hour response time support to get the server fixed if...

After a couple of searches, the only database system that I can find that has a "sequential backup" is MyBB. Here's a forum for that [/url]if that's what you're looking...

You'll need to JOIN between Casting and Actor to get the actors. You'll want to GROUP BY a count of the actors from the Casting table for each movie. Then,...

All those are server resource measurements, which are interesting and can suggest if you have a problem. But, to quickly determine if things are running long (whether they're maxing out...

If you do some searches there are several scripts for monitoring for blocked processes that's one I'd set up. Timing is different on every environment though. I'd also suggest getting...

Databases exist in two places in Azure, in Azure Virtual Machines and in Microsoft Azure SQL Database (MASD). The VMs act exactly like physical boxes or VMs local to your...

ScottPletcher (8/15/2014)

---

What is(are) the clustering column(s) on the table? You need to read each 1/4 of the table at a time using the appropriate clustering key range.

What are there...

None at all. If you're only temporarily moving them to 2005, I'd skip the update stats step there, but in general it can't hurt at all to have a fresh...