Viewing 13 posts - 1 through 13 (of 13 total)
Does this script work for anyone? I get a zero result set when I know that I am using a table with assummed but not materialized foriegn key relationships by...
September 28, 2010 at 12:54 pm
Do you have the exact execution command?
July 20, 2004 at 2:45 pm
One primary key based on the DOcument Identifier which is a GUID.
A primary key by default is a clustered index. You may want to make this a simple unique...
July 20, 2004 at 2:10 pm
When you look at the execution plan take note of any book mark look ups and plan your indexes around them.. The optimal solution here would be a clustered index...
July 20, 2004 at 1:33 pm
Locks are another issue if the system is highly transactional you want to take transaction log snapshots during the day and diffs or fulls at night. The drive performance will...
July 20, 2004 at 1:28 pm
The above comment is correct you need to include a logical else and tell it what to do if it finds a null.
July 20, 2004 at 1:17 pm
Three Reasons for DTS over Linked Server:
1: The DTS Data pump Item will allow you to set commit batch size per transaction which will improve overall performance and reduce the...
July 20, 2004 at 1:13 pm
There isnt any way really to optimize the BCP portion of snapshot reintialization. I would suggest unfortunately to eliminate the network as the others have suggested and burn to DVD.
June 25, 2004 at 12:39 pm
How big are your snapshots?? in MB just a ballpark
June 25, 2004 at 10:30 am
These stored procs will remove lingering replication systems settings on both the subscriber and the publisher's sides of replication.
Run on Subscriber Server.
Run sp_RemoveDBReplication "[Subscriber Database Name]"
Run on Publisher Server.
June 25, 2004 at 9:58 am
Which server is enabled as a distributor? aka. Has the distribution database on it.
June 25, 2004 at 9:54 am
Is the replication within your LAN or are you trying to replicate out over a T1 or Something? Also are the Snapshots being generated local to the distributor or on a...
June 25, 2004 at 9:51 am
and table_name = '''+@destination_TableName+'''
February 6, 2004 at 10:02 am