Viewing 15 posts - 37,126 through 37,140 (of 39,818 total)
I've seen some long rollbacks. Can you define forever?
I wouldn't be surprised if the process notifies 100%, but still is doing cleanup (like deleting log entries or something).
Can you tell...
September 27, 2002 at 8:52 am
Personallly I've been to a number of conferences (PASS, TechEd, PDC, etc.) and I've found that the more junior you are, the more you learn from the seminars. As I've...
September 27, 2002 at 8:28 am
What do you mean the output is the same as if you don't run WITH TABLERESULTS?
I suspect that this is due to the fact the a recordset is not returned...
September 26, 2002 at 10:32 am
Improve processes, make them run faster. Look for holes in your processes. Automate things that I do. Performance monitoring and tuning if I can get time.
Steve Jones
September 26, 2002 at 10:23 am
select @cmd = 'del E:\backups\' + @DELETE
xp_cmdshell @cmd
Steve Jones
September 26, 2002 at 10:20 am
No. this is an incremental field and the increment is stored in the system tables. Someone can alwyas insert their own value or the next value can be reset.
http://www.sqlservercentral.com/columnists/sjones/understandingyouridentity.asp
http://www.sqlservercentral.com/columnists/sjones/identitylocking.asp
Steve Jones
September 26, 2002 at 10:13 am
Lots of other solutions I know, but this one met our needs and worked nicely.
Thanks for the suggestions.
Steve Jones
September 26, 2002 at 10:05 am
None here. also none with the cumulative patch
Steve Jones
September 25, 2002 at 5:02 pm
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
Viewing 15 posts - 37,126 through 37,140 (of 39,818 total)