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

Content with tags Administration, Distributed Queries Rss

   Items 1 to 3 of 3   

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

Adding Linked Servers Using SQL-DMO

Following up on a question posted in our discussion area, Andy looks at how to use DMO to add and remove linked servers. Along the way he points out a couple 'gotchas' and throws in a cool tip about how to save a little time when you experiment with DMO.   Read more...
By Andy Warren 2002/09/19 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 12,124 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,161 reads
   Items 1 to 3 of 3   
configuring (3)    
sql server 7 (3)    
miscellaneous (2)    
performance tuning (2)    
replication (2)    
backup and restore (1)    
dts (1)    
english query (1)    
indexing (1)    
installation (1)    
monitoring (1)    
openxml (1)    
programming (1)    
security (1)    
sql-dmo (1)    
stored procedures (1)    
triggers (1)    
t-sql (1)    
updategrams (1)    
user defined function (udf) (1)    
visual basic 6 (1)    
xml (1)    
xsl (1)