Re: Distribution Data File Growth

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "Paul Ibison" <Paul.Ibison@xxxxxxxxxxxxx>
Date: Thu, 14 Apr 2005 22:39:35 +0100

Well over a million records is quite a lot, but I'd be surprised if this
amounts to 1GB. Running, sp_spaceused will give the exact ratio of empty to
used space in the database. If the subscriber(s) have synchronized and are
up to date, you could reduce the retention period and run the cleanup agent
to remove a big chunk of this data but this will only work if anonymous
subscribers aren't enabled.
Rgds,
Paul Ibison SQL Server MVP, www.replicationanswers.com/default.asp
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

.

References:
- Distribution Data File Growth
  - From: michelle
- Re: Distribution Data File Growth
  - From: Paul Ibison
- Re: Distribution Data File Growth
  - From: michelle

Prev by Date: One way merge?
Next by Date: Transaction Replication
Previous by thread: Re: Distribution Data File Growth
Next by thread: Re: Distribution Data File Growth
Index(es):
- Date
- Thread

Relevant Pages

Re: DTS bug (?): Data Driven Query Task incorrectly replaces empty strings with NULL.
... DataPump task works as expected so it is not something that DTS cannot ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... >> Allan Mitchell MCSE,MCDBA, ...
(microsoft.public.sqlserver.dts)
Re: DTS bug (?): Data Driven Query Task incorrectly replaces empty strings with NULL.
... DataPump task works as expected so it is not something that DTS cannot ... Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ... >> Allan Mitchell MCSE,MCDBA, ...
(microsoft.public.sqlserver.server)
Re: Data Types and Storage
... I agree that you may get more centric answers in some SQL Server ... code it refer to DBNull) rather than the empty string. ... NVarChar and Varchar differ on the underying persisting charset of ... If I see it right, it's solely related to the database, ...
(microsoft.public.dotnet.languages.vb)
RE: Database import wizard in sql server 2005
... I created a coupld ssis packages via SQL Server 2005 Import and Export Wizard. ... I have a lot of empty date fields in source file), ...
(microsoft.public.sqlserver.dts)
Re: Server-side cursors for ResultSets - a pattern? (and what about Oracle?)
... Oracle and SQL Server, with the least possible amount of differences. ... The reason for this anti-performance request: ... you typically will get limited amounts of result set ...
(comp.lang.java.databases)