I'd really check the values in the Structured Storage file. There were issues in the past where something wouldn't show up in the designer, but still existed in the VB...

I assume you're reading from Performance Monitor. If not let us know.

I don't think I've ever seen this counter die, but as Colin mentioned, usually all the SQL counters will...

BTW, both of these create recovery issues since you have to install something on a new server in a DR situation. Make sure you update documentation and keep copies of...

I know I've seen the green arrow, but can't remember what trick to use.

There are issues with sending mail SMTP via Outlook. For some reason they "stick" in the outbox...

Be careful backing up to drives not local to the machine. Network backups sometimes cause issues.

Depends 😉

If you have heavy tempdb or log usage (based on transactions), then you might get a performance improvement. Keep in mind that data files usually have lots of random...

(possibly) stupid question. Users have run queries on this, right?

As soon as something is read into the buffer, I'd assume the next query should get some type of hit.

The...

The only difference I'm aware of is when the connection is made. After that, things should run the same.

Can you provide more details on what seems slow? I wouldn't think...

From what I've heard from the PSS guys at Microsoft, don't change the worker threads unless they help you determine this. You can get unexpected results.

That's not really a place...

I think you're ok with memory as well, but with 8GB, you probably want to give 6-6.5 to SQL and see if performance improves

Make sure you have AWE on and...

It doesn't always start itself. Might be more consistent in 2000, been awhile since I've worked with this, but I know it used to need to be started.

There are two...

DBCC CHECKDB will check the consistency of a database.

There is no check for a server.

Do you know what you're trying to do? A "healthy" server could mean any...

What is Integration SQL DB?

I'm not sure why the results would be different. Is there data that's greater than 4000 char and might be getting lost in an implicit conversion?

Also,...

What app is this?

Clipped should be Fox 2.x or dBase IV if I remember. I'd think that any DBase driver would read it.

Use the Import Wizard in SQL Enterprise Manager and try some...