If it's a cube refresh, then it should be running scheduled out of...

Just checking... I keep running into people who think full backups without copy_only break the log chain, so....

Worked at a bank 5 years.

Denying permission is probably easiest, unless the damn...

You have differential backups as part of your backup strategy?

The list of DDL operations that can have a trigger created on them is listed here: http://msdn.microsoft.com/en-us/library/bb522542.aspx, and backup database is...

You definitely have redundant indexes. Here's just one example

CREATE INDEX [missing_index_133_132_PhoneLink] ON [LP_LIve_Data].[dbo].[PhoneLink] ([CustomerID]) INCLUDE ([ID], [VendorID], [PhoneID], [PhoneTypeID], [DefaultPhone], [LocationID], [ProgramID]);

CREATE INDEX [missing_index_135_134_PhoneLink] ON [LP_LIve_Data].[dbo].[PhoneLink] ([CustomerID]);

You, or whoever created...

What is anyone going to do with 9 million rows being returned for a report? No one, ever, is going to read more than a small portion of that.

Start by...

From a quick glance, drop them all and then do a proper index analysis and tuning exercise that doesn't involve creating everything the missing index DMV says. You've got lots...

From a single glance, very dangerous to guess.

To be sure, you need to record the values from that DMV on a regular basis for at least a month and...

Ah-hoc query, SQL from an app.

If nothing at all is running in parallel, there should be no cxpacket (though maybe some system stuff can ignore the maxdop setting, not sure)

Server maxdop can be overridden.

If your instance is MAXDOP 1 and I run a query with OPTION(maxdop 8), my query can parallel up to 8 threads. That's probably what's happening.

And the profound post of the day award goes to:

That's the entire post.

Plus, adding a nullable varchar column is, as far as I recall, a metadata only operation, so it's going to be extremely fast. It does need an exclusive schema lock,...

What are you trying to do? The code doesn't make any sense.

You're trying to attach a SQL Server...

enriquemallon (8/13/2014)

---

The unit of work was initiated before DDF was started, and the application attempted to perform a distributed operation. The unit of work must be terminated by a rollback...

Can you temporarily move one of those other databases somewhere else?

Their recovery model is irrelevant, I just want to know if you can make some space on the drive.