Resource governor is not configured.

Max SQL memory...

Grant Fritchey (8/5/2014)

---

Wait a sec, if you're offloading DBCC checks, the one check you can't offload is PHYSICAL_ONLY. That one check must still be run on the original. Then, it's...

GilaMonster (8/5/2014)

---

You miss some corruptions. Physical only is designed as a limited set of checks for frequent checks of busy servers. Since you're offloading the checks to another server, there's...

What are the drawbacks?

Thanks

Here's one I've been concentrating on since most of our databases are around this...

Beatrix Kiddo (8/1/2014)

---

😀

It genuinely can be quicker to get on a plane with a hard...

I tried to run a couple installs recently using the .ini files, but got errors when assigning my service account to the SQL and Agent services because they required passwords....

Thanks. I'm still trying to find a thorough checklist for a similar situation. Thankfully this isn't due for a couple days.

I have those steps planned because I've been asked to not shut the server down until the VM is up and running for testing, in case we need to back...

Sort of, with the end result being rebuilt CMS tables. I guess I'm not sure what from the XML file is supposed to end up where.

Heh.

Msg 6841, Level 16, State 1, Line 166

FOR XML could not serialize the data for node 'NoName' because it contains a character

(0x0012) which is not allowed in XML. To...

Good call on that. Doing this sort of forced me to look at the underlying table structure of the half-aliased mess of a view I inherited. I have the below...

ScottPletcher (7/14/2014)

---

Not sure specifically what you're looking for, maybe this can help:

;WITH

cteTally10 AS (

SELECT 0 AS tally UNION ALL SELECT 1 UNION ALL SELECT 2 UNION...

I don't think there's going to be one in NYC this year :angry:

I think you nailed it. Both times when it happened I was pulling the actual execution plan for a dead pig of a stored procedure.

Thanks