[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Re: Large xml processing into SQL Server

• To: "william.j.boxall@a..." <william.j.boxall@a...>
• Subject: Re: Large xml processing into SQL Server
• From: Michael Champion <michaelc.champion@g...>
• Date: Fri, 7 Jan 2005 15:36:42 -0500
• Cc: XML Developers List <xml-dev@l...>
• Domainkey-signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=dV1nSW6FDSy0cFhmPhJkf2xfP5n83hoRKZHjI5nITbc3m2enVEg2bFyD2CCZWga5s5Wiz85b+aKVdYjbdyu0YkDX8wBoJ2BPZkV30y7PpCNFEJHjxvnOSPHM4uNdoutC13v013M/DSWZ49PPdwQQJE88jGi7Kgs0f7WR5/jBWds=
• In-reply-to: <5FA491FA70F4AD43B6C3ECA9B39E441614AF25@A...>
• References: <5FA491FA70F4AD43B6C3ECA9B39E441614AF25@A...>
• Reply-to: Michael Champion <michaelc.champion@g...>

On Fri, 7 Jan 2005 14:14:18 -0600, william.j.boxall@a...
<william.j.boxall@a...> wrote:

> Thank you all who have offered to help!

Have you looked at
http://www.awprofessional.com/articles/article.asp?p=102307 ?  It's a
sample chapter" Using SQL Server's XML Support"  By Ken Henderson.
from The Guru's Guide to SQL Server Architecture and Internals.
(Addison Wesley Professional.) It discusses bulk loading.

Since your file seems to be structured into relatively simple records,
can you just break up the file into smaller chunks?

• References:
  • RE: Large xml processing into SQL Server
    • From: <william.j.boxall@a...>

• Prev by Date: RE: Large xml processing into SQL Server
• Next by Date: RE: Large xml processing into SQL Server
• Previous by thread: RE: Large xml processing into SQL Server
• Next by thread: RE: Large xml processing into SQL Server
• Index(es):
  • Date
  • Thread