http://www.sqlservercentral.com/Content tagged T-SQL, XML, Miscellaneous posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)In the previous articles, Jacob Sebastian looked at using XML to save a sales order with variable numbers of line items to a SQL Server 2000 database. In this part, he expands upon the processing to access that data from multiple nodes. http://www.sqlservercentral.com/articles/Miscellaneous/2911/2007/04/03http://www.sqlservercentral.com/articles/Miscellaneous/2911/In the first part of this series, Jacob Sebastion showed us how to use XML to save a sales order to the database with a variable amount of line items. In part 2, he continues looking at XML in SQL Server 2000 with some advanced XML processing. http://www.sqlservercentral.com/articles/Miscellaneous/2909/2007/03/29http://www.sqlservercentral.com/articles/Miscellaneous/2909/How many times have you tried to save a sales order to your database? For many DBAs this is a common scenario and one of the challenges is the many round trips for the various line items. Jacob Sebastian brings us the first part of a four part series looking at how you can use XML to reduce the round trips in SQL Server 2000. http://www.sqlservercentral.com/articles/Miscellaneous/2908/2007/03/27http://www.sqlservercentral.com/articles/Miscellaneous/2908/The fourth and final installment in this series, this week Andy discusses how using XML can reduce the load you put on your network and on your server. This is a high level article that discusses concepts. We think you'll find a good idea or two in this one! http://www.sqlservercentral.com/articles/Performance+Tuning/reducingroundtripspart4/665/2004/04/23http://www.sqlservercentral.com/articles/Performance+Tuning/reducingroundtripspart4/665/New Author! Stephan writes about why he thinks the bulk load capabilities added in the SQLXML3 addition are a great way to handle imports - maybe so good that you'll stop using BCP. http://www.sqlservercentral.com/articles/Miscellaneous/replacingbcpwithsqlbulkload/1055/2003/07/21http://www.sqlservercentral.com/articles/Miscellaneous/replacingbcpwithsqlbulkload/1055/A monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks! http://www.sqlservercentral.com/articles/Installation/reviewofsql2000fastanswers/959/2003/04/18http://www.sqlservercentral.com/articles/Installation/reviewofsql2000fastanswers/959/Last week Andy started a discussion of the various ways you can reduce the number of round trips to the server. This week he continues by looking at a method he used recently to do client side caching of data to eliminate the round trip altogether. Gotta read it! http://www.sqlservercentral.com/articles/Performance+Tuning/reducingroundtripspart2/588/2002/02/06http://www.sqlservercentral.com/articles/Performance+Tuning/reducingroundtripspart2/588/XML support in SQL Server lives up to the hype that's always surrounded XML. Using SQL Server 2000, you can send queries over HTTP, save XML records to the database, and retrieve records via XML. This article shows how you can take advantage of these features in SQL Server 2000 by building a database entry system that keeps track of sales and customer information. http://www.sqlservercentral.com/redirect/articles/574/2002/01/28http://www.sqlservercentral.com/redirect/articles/574/Microsoft® SQL Server 2000 introduced several new features for querying database tables and receiving the results as an XML document. Web release 1 of SQLXML (XML for SQL Server) added Updategrams and XML Bulk Load functionality, as well as a host of other features to the SQL Server 2000 base. http://www.sqlservercentral.com/redirect/articles/485/2001/10/29http://www.sqlservercentral.com/redirect/articles/485/