Viewing 13 posts - 1 through 14 (of 14 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...
============================
Richard S. Hale
Senior Database Marketing Developer
Business Intelligence
The Scooter Store
RHale@TheScooterStore.com
DSK: 830.627.4493
September 28, 2010 at 12:54 pm
Do you have the exact execution command?
============================
Richard S. Hale
Senior Database Marketing Developer
Business Intelligence
The Scooter Store
RHale@TheScooterStore.com
DSK: 830.627.4493
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...
============================
Richard S. Hale
Senior Database Marketing Developer
Business Intelligence
The Scooter Store
RHale@TheScooterStore.com
DSK: 830.627.4493
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...
============================
Richard S. Hale
Senior Database Marketing Developer
Business Intelligence
The Scooter Store
RHale@TheScooterStore.com
DSK: 830.627.4493
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...
============================
Richard S. Hale
Senior Database Marketing Developer
Business Intelligence
The Scooter Store
RHale@TheScooterStore.com
DSK: 830.627.4493
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.
============================
Richard S. Hale
Senior Database Marketing Developer
Business Intelligence
The Scooter Store
RHale@TheScooterStore.com
DSK: 830.627.4493
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...
============================
Richard S. Hale
Senior Database Marketing Developer
Business Intelligence
The Scooter Store
RHale@TheScooterStore.com
DSK: 830.627.4493
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.
============================
Richard S. Hale
Senior Database Marketing Developer
Business Intelligence
The Scooter Store
RHale@TheScooterStore.com
DSK: 830.627.4493
June 25, 2004 at 12:39 pm
How big are your snapshots?? in MB just a ballpark
============================
Richard S. Hale
Senior Database Marketing Developer
Business Intelligence
The Scooter Store
RHale@TheScooterStore.com
DSK: 830.627.4493
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.
...
============================
Richard S. Hale
Senior Database Marketing Developer
Business Intelligence
The Scooter Store
RHale@TheScooterStore.com
DSK: 830.627.4493
June 25, 2004 at 9:58 am
Which server is enabled as a distributor? aka. Has the distribution database on it.
============================
Richard S. Hale
Senior Database Marketing Developer
Business Intelligence
The Scooter Store
RHale@TheScooterStore.com
DSK: 830.627.4493
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...
============================
Richard S. Hale
Senior Database Marketing Developer
Business Intelligence
The Scooter Store
RHale@TheScooterStore.com
DSK: 830.627.4493
June 25, 2004 at 9:51 am
SELECT
column_name name,
constraint_name name
FROM
'+@destination_DatabaseName+'.information_schema.key_column_usage
WHERE
constraint_catalog='''+@destination_DatabaseName +'''
and table_name = '''+@destination_TableName+'''
ORDER BY
constraint_name, ordinal_position
============================
Richard S. Hale
Senior Database Marketing Developer
Business Intelligence
The Scooter Store
RHale@TheScooterStore.com
DSK: 830.627.4493
February 6, 2004 at 10:02 am
Viewing 13 posts - 1 through 14 (of 14 total)