Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags XML, Performance Tuning Rss

   Items 1 to 6 of 6   
 

SQL Server 2008 Table Valued Parameters Performance

An article from Scott Zurolo tests the terformance of SQL Server 2008 Table Valued Parameters against more traditional methods of updating many rows at once.  Read more...
By Scott Zurolo 2010/07/08 | Source: SQLServerCentral.com | Category: tvp
Rating: |  Discuss |   Briefcase | 9,491 reads

Performance Optimizations for the XML Data Type in SQL Server 2005

This paper explores several ideas to improve the query and data modification performance of the XML data type in Microsoft SQL Server 2005. To get the most value from this paper, you need to be familiar with the XML features in SQL Server 2005. For background material, see XML Support in Microsoft SQL Server 2005 and XML Best Practices for Microsoft SQL Server 2005 on the Microsoft Development Network (MSDN)  Read more...
By Additional Articles 2008/08/01 | Source: TechNet Blogs | Category: xml
Rating: (not yet rated)  Rate this |   Briefcase | 2,032 reads

SQL Server XML Performance Tips

A series of tips on optimizing XML in your SQL Server databases.   Read more...
Rating:  Rate this |   Briefcase | 3,231 reads

Reducing Round Trips Part 4

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!   Read more...
By Andy Warren 2004/04/23 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 8,948 reads

Review of SQL 2000 Fast Answers

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!   Read more...
By Andy Warren 2003/04/18 | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 18,205 reads

Reducing Round Trips - Part 2

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!   Read more...
By Andy Warren 2002/02/06 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 9,233 reads
   Items 1 to 6 of 6   
 
Tags
t-sql (4)    
miscellaneous (3)    
sql server 7 (3)    
basics (2)    
openxml (2)    
administration (1)    
ado (1)    
backup / restore (1)    
configuring (1)    
database design (1)    
distributed queries (1)    
dts (1)    
english query (1)    
indexing (1)    
installation (1)    
monitoring (1)    
programming (1)    
replication (1)    
security (1)    
sql server 2005 (1)    
stored procedures (1)    
triggers (1)    
tvp (1)    
updategrams (1)    
user defined function (udf) (1)    
visual basic 6 (1)    
xsl (1)