Posted by Hugo Kornelis on 09/29/89 11:53

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

• Next in forum: Re: ms sql 2005
• Prev in forum: Re: SQL Generator
• Thread view: Re: Reduce Table Size without deleting data

[Reply to this message]