Viewing 15 posts - 31,126 through 31,140 (of 39,823 total)
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...
October 8, 2007 at 8:02 am
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...
October 8, 2007 at 7:54 am
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...
October 8, 2007 at 7:51 am
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...
October 8, 2007 at 7:51 am
Be careful backing up to drives not local to the machine. Network backups sometimes cause issues.
October 7, 2007 at 9:42 pm
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...
October 7, 2007 at 9:35 pm
(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...
October 7, 2007 at 9:33 pm
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...
October 7, 2007 at 9:31 pm
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...
October 7, 2007 at 9:30 pm
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...
October 7, 2007 at 9:28 pm
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...
October 7, 2007 at 9:23 pm
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...
October 7, 2007 at 9:20 pm
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,...
October 7, 2007 at 9:19 pm
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...
October 7, 2007 at 9:15 pm
Viewing 15 posts - 31,126 through 31,140 (of 39,823 total)