Viewing 15 posts - 241 through 255 (of 285 total)
I know people are busy, and I'm not against notifications, I just wish that the notification was just that, a notification and didn't contain the text of the post. Curious...
January 7, 2004 at 8:37 am
quote:
Try undocumented DBCC PSS with your SPID, it should sugest the status of the process, and then you can decide whether you...
December 17, 2003 at 12:12 pm
quote:
Thanks to all who replied. This leads to a follow up question. In that master, model and msdb are in simple recovery...
December 17, 2003 at 7:01 am
I got around a similar problem by using "-w1000" on the osql command and by changing the properties of the DOS window:
Right click on the "C:\" graphic in the DOS...
December 17, 2003 at 6:42 am
These kinds of responses to a seemingly elementry question (at least for people who have worked with SQL Server for an extended period of time) are why I like this...
December 17, 2003 at 6:29 am
Is there any way to block the annoying animated SQL LiteSpeed ad? It appears on virtually every web page, and it is very distracting. I’d be happy just to get...
December 10, 2003 at 7:06 am
John,
(Maybe I should start a separate thread.) I'm still looking a product to improve SQL Server backup/restore times. Do you have any performance stats for LiteSpeed that you could post?...
August 20, 2003 at 6:53 am
quote:
LiteSpeed restores are far quicker when dealing with VLDBs.
ev4nsj,
Out of curiosity, how large is your...
August 20, 2003 at 5:18 am
Sometimes you can monitor the progress of a rollback with (assuming that the spid is 53):
kill 53
kill 53 with statusonly --if time remaining displays as 0, then the process may...
August 19, 2003 at 12:03 pm
Sometimes you can monitor the progress of a rollback with (assuming that the spid is 53):
kill 53
kill 53 with statusonly --if time remaining displays as 0, then the process may...
August 19, 2003 at 12:03 pm
quote:
There are other implications that were not mentioned here like:DTS DOESN'T WORK on fiber mode and that is huge for some enviroments.
August 13, 2003 at 11:31 am
Thanks for the feedback, but a coworker and I finally got it to work for free.
Jon
August 4, 2003 at 5:10 am
>>To use AWE memory, you must run the SQL Server 2000 database engine under a Windows 2000 account that has been assigned the Windows 2000 lock pages in memory privilege....
July 14, 2003 at 1:43 pm
>>Can you post the result of sp_configure here?
name ...
July 14, 2003 at 12:49 pm
>>Which edition of SQL Server you are running?
SQL 2000 Enterprise Edition
>>How much addtional memory did you add?
We went from 4 GB to 6 GB.
>>How large is your database?
There are...
July 14, 2003 at 12:48 pm
Viewing 15 posts - 241 through 255 (of 285 total)