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...

I tend to agree with Paul. Unless you are in the millions of rows range, then it doesn't necessarily help you to partition.

So what do you want from this result? You need to define the criteria for what you want. It's not enough to say I want the first row, but define...

Yep, you need to grab the trial version, use restore only mode.

You could download a trial of Litespeed, which has the extractor.exe program to convert to native backup format.

I'll ping people and see if I can find a licensed copy.

Both programs convert to native, which all can use.