SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags Performance Tuning, Replication Rss

   Items 1 to 4 of 4   

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,208 reads

Tips for Performance Tuning SQL Server Transactional Replication

From this real-world case study, learn how you can boost SQL Server performance and scalability by off-loading reporting from your production SQL Server to a reporting server, using transactional replication.   Read more...
By Additional Articles 2002/04/18 | Source: SQL Server Performance | Category: replication
Rating:  Rate this |   Briefcase | 1,852 reads

Middle Tier Application Data Caching with SQL Server 2000

Middle tier applications often use a single database management system (DBMS) to store data, which can expose scaling limitations as the number of user requests increases. Caching, a technique used to increase application performance by copying data and then using the copied data in place of the original data, can dramatically increase the throughput (the number of application requests serviceable per unit time) and scalability of middle tier applications.   Read more...
By Additional Articles 2002/03/08 | Source: Microsoft SQL Home | Category: administration
Rating:  Rate this |   Briefcase | 2,079 reads

Diagnosing and Troubleshooting Slow Partitioned Merge Processes

Direct from Microsoft, learn how to achieve scalable, high-performance merge replication applications.   Read more...
By Additional Articles 2002/02/08 | Source: Microsoft MSDN | Category: replication
Rating:  Rate this |   Briefcase | 1,648 reads
   Items 1 to 4 of 4   
sql server 7 (4)    
administration (2)    
configuring (2)    
distributed queries (2)    
miscellaneous (2)    
t-sql (2)    
backup and restore (1)    
dts (1)    
english query (1)    
indexing (1)    
installation (1)    
monitoring (1)    
openxml (1)    
security (1)    
stored procedures (1)    
triggers (1)    
updategrams (1)    
user defined function (udf) (1)    
xml (1)    
xsl (1)