Also know that the optimizer, with one exception, treats a parameter (before the AS) and a variable (after the AS) differently. A parameter value is known to the optimizer when...

I would not take a single suggestion from the Database Tuning Advisor as safe. I would assume that each and every suggestion is suspect until I tested it. I do...

Not seeing where someone said not to use differential backups or am I misunderstanding?

Yeah, that makes more sense, and yes, it should just roll back to where things were.

Jeff Moden (12/22/2013)

---

Grant Fritchey (12/20/2013)

---

For just getting started, these are the things[/url] that I immediately look at for a plan. Yeah, there are tons more details, but this is the...

I'd see if you can recover that file and get your database back online.

Then, let this be a lesson, get good backups in place. Especially before you start modifying structures.

Not with a missing data file. You have to have that.

You'll need to restore this database from a backup. Or, if you have detached the files, you'll need to go through an attach process. Without all the data files, you...

Sorry. Not a comvault person. Do they have a forum? You might post there to see what people say.

Based on what you're saying, I'm pretty sure it's 8 for each machine, not shared. Unless you're running active/active and the instances are both on one server. Then, it's shared...

I'm with Kevin. It sounds like OS and possibly 32bit.

You can create a primary key and use the word NONCLUSTERED to force it to not be a clustered index.

But, other than that, you've got the answer. Unique constraints create...

Not sure why it would fail. The worst thing that would happen is you're blocked for the duration of the backup process, but even that shouldn't cause any issues. Are...

The log only grows from failure of the log backups. It won't grow due to failed differentials or failed full backups.

Another way to audit your backups, in addition to alerts...

SQLRNNR (12/20/2013)

---

Jack Corbett (12/20/2013)

---

WayneS (12/20/2013)

---

I'm curious as to the different ways that you fine folks have seen / dealt with being on-call, and what you perceive the pros/cons...