I'd second Lynn's article. It's a good discussion of this topic.

You might have deleted the plan, but there wasn't RI in the system tables to clear out the subplan. That wouldn't surprise me. I can't make it happen, but it's...

A few link:

http://sqlcat.com/whitepapers/archive/2009/08/13/a-technical-case-study-fast-and-reliable-backup-and-restore-of-a-vldb-over-the-network.aspx

What version of RG? A TB database isn't that big these days with TB drives.

Jeffrey is right. Don't play with simple mode, unless you are going to run a full backup first, AND make sure you have a second copy off the machine before...

That sounds high to me. I would look at building a reindexing procedure that only reindexes those tables that need it. There are lots of scripts on this site that...

Jeff Moden (5/27/2010)

---

On a similar note, I've been thrown into supporting Great Plains with mods from a 3rd party vendor (haven't quite figured that one out, yet :Whistling:)... The systems...

There likely isn't a memory change significantly. As you query the data, it will get put in the cache, regardless of which table it's from. In terms of indexing, if...

Perhaps the wrong one is gone?

The error you give relates to a row in dbo.sysmaintplans_subplans. You should be able to query the tables in MSDB to get more information...

No changes in the format for a few months. We actually have an XSD document that transforms a bunch of data returned by various queries. It's been a stable template...

I have removed the sentence about error messages since it was confusing.

What is "control m" jobs? Where did you see this? It doesn't make sense to me.

What sizes are we talking about? I'm curious what "big" and "huge" are on your system.

I second Lynn's suggestion. You don't need to rebuild all indexes every day.

Everyone wants to stop the log. Until they lose some data, then they want more of a log.

Interesting idea, though search is a hard thing to solve. We have our own issues here, but I understand what you're asking.

Part of the difficulty that I see is determining...

You'd have to be able to query the network to determine this. At any time, only one Windows name is allowed on the network, so that's unique, but you can...