Viewing 15 posts - 37,036 through 37,050 (of 39,720 total)
September 24, 2002 at 9:43 am
Do you mean you tried performance tuning?
The impact depends on your environemnt. If things are running well, you may not be able to squeeze noticable improvement.
Steve Jones
September 23, 2002 at 10:55 am
Haven't seen invalid pointer. Can you run the job steps manually? What are the jobs (their steps?).
Steve Jones
September 23, 2002 at 10:50 am
Sounds like app trouble. Can you drop the physical file and let the backup recreate it?
Steve Jones
September 23, 2002 at 10:47 am
I know that there was a bug where XP_RemoveDoc wasn't releasing memory. Which SQL Version is this and which SP? Have you rebooted and are able to run it at...
September 23, 2002 at 10:44 am
My vote is ADO connection. Easier to control and troubleshoot. Just personal preference.
Steve Jones
September 23, 2002 at 10:41 am
The msgbox is hanging a scheduled job. Remove it and see if that fixes it.
Steve Jones
September 23, 2002 at 10:37 am
A clustered index will physically move pages, so this might help. Maybe create one and then delete it.
A stored proc will not work for truncate. If you don't have rights,...
September 23, 2002 at 10:25 am
Antares has good advice. We have a large warehouse that has 3 files in a filegroup (separate arrays) + a 4th for some indexes. Has really helped performance.
Steve Jones
September 23, 2002 at 10:22 am
Can you copy the files? If so, copy them to a new location and attach only the MDF. Let it create a new LDF.
Steve Jones
September 23, 2002 at 10:09 am
Haven't seen this, but I have seem similar flaky installs with SQL 2000.
May need to contact MS for this one. Likely some registry issue.
Steve Jones
September 23, 2002 at 10:04 am
Try a clustered index rebuild. Might not be releasing pages. Haven't seen this, but I don't think I have anything like this in production.
Steve Jones
September 23, 2002 at 10:00 am
you need to run thsi from master, not the database. If you have EM open with the database selected, you are "using the database". You need to be connected to...
September 20, 2002 at 11:40 am
September 20, 2002 at 11:39 am
Viewing 15 posts - 37,036 through 37,050 (of 39,720 total)