Viewing 15 posts - 16 through 30 (of 230 total)
Is there a way to just easily disable snapshot replication?
June 9, 2003 at 9:40 pm
"Using this procedure prevents Microsoft® SQL Server™ 2000 from replicating the database until the database is unpublished and republished."
How does one do a "unpublished and republished"?.
June 9, 2003 at 1:35 pm
will this work for snapshot replication?
what are the effects of running this?
are there any parameters I should include for this procedure?
June 9, 2003 at 12:24 pm
I do not want to delete all the publications at this point.
Is there another way to shrink this log?
June 9, 2003 at 10:32 am
isn't there an easier way?
When I run DBCC LOGINFO(db), the FILEID shows 2 for about 600 rows. This is the reason it will not shrink correct?
June 9, 2003 at 7:19 am
Note:
It's the Publisher database that I am concerned about there.(30 gb log file and growing.)
June 8, 2003 at 9:37 pm
This is snaphot replication. Should the logreader still be running continously?
June 8, 2003 at 9:23 pm
ya the lock duration is the main thing. My point was the SELECT..INTO has more overhead with locks.
What will a perm. table with the spid as a column do?...
February 1, 2003 at 4:43 pm
(SQL Server 2000)
The interesting thing about the different ways to create temp tables is the number of locks help by each SPID.
Two coding techniques are:
1. SELECT..INTO #
2. CREATE TABLE #,...
February 1, 2003 at 1:55 pm
Here's one sample that is causing contention. (Sorry could not put in the exact code.)
I am concerned about the temp table creation here and the resulting blocks/locks this may cause...
February 1, 2003 at 8:58 am
I am seeing alot of LOCK:TIMEOUTS with tempdb(syscolumns and sysobjects.)
Anywhere to look to find the root cause?
January 30, 2003 at 4:46 pm
Viewing 15 posts - 16 through 30 (of 230 total)