Re: Reduce Table Size without deleting data

From: Hugo Kornelis <hugo@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
Date: Thu, 20 Jul 2006 23:16:29 +0200

On Thu, 20 Jul 2006 14:23:50 GMT, iamset via SQLMonster.com wrote:

(snip)

I am ready to explore ideas and suggestions; I am still new to the DBA world,
I am out of ideas.

Hi iamset,

You might wish to explore distributed partitioned views. Looks like
they're the exact right tool for this job.

Books Online has good information on them.

--
Hugo Kornelis, SQL Server MVP
.

References:
- Reduce Table Size without deleting data
  - From: iamset via SQLMonster.com

Prev by Date: Re: SQL Generator
Next by Date: Re: ms sql 2005
Previous by thread: Reduce Table Size without deleting data
Next by thread: DTS export to Excel
Index(es):
- Date
- Thread

Relevant Pages

Re: Rqst for Inventory Database Best Practices
... Hugo Kornelis, SQL Server MVP ... Prev by Date: ...
(comp.databases.ms-sqlserver)
Re: A basic question: Removing duplicate results from Max function
... Here's a third suggestion: ... Hugo Kornelis, SQL Server MVP ...
(comp.databases.ms-sqlserver)
Re: Nested select
... Order column is NOT NULL...) ... Hugo Kornelis, SQL Server MVP ...
(microsoft.public.sqlserver.mseq)
Re: Help with Query
... Please don't post copies of the same question to multiple locations; ... Hugo Kornelis, SQL Server MVP ...
(comp.databases.ms-sqlserver)
Re: Angband 3.0.7s3
... Another, probably mildly annoying, release of Angband "3.0.7s". ... really almost entirely other people's work; thanks go to Hugo Kornelis, ... Pete Mack, ... <SNIP> ...
(rec.games.roguelike.angband)