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

Content with tags Performance Tuning, Administration, SQL Server 7 Rss

<< Newer    Items 21 to 25 of 25   
 

Stored Procedures and Caching

One of the biggest performance gains built into SQL Server is the stored procedure. In this article by Brian Kelley, he shows you how to fully utilize, debug and monitor the caching of such objects.   Read more...
By Brian Kelley 2004/11/19 (first published: 2002/01/28) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 40,702 reads

How to Setup Log Shipping with SQL 2000

This white paper outlines the following: -The steps to configure Log Shipping between two or more servers that are running SQL Server 2000 Enterprise Edition. -The steps to configure Log Shipping between Microsoft SQL Server 7.0 Service Pack 2 (SP2), or later, and Microsoft SQL Server 2000 Enterprise Edition. -A brief comparison between Log Shipping and the other high availability-solutions that SQL Server provides.   Read more...
By Additional Articles 2002/01/25 | Source: Microsoft MSDN | Category: administration
Rating:  Rate this |   Briefcase | 1,498 reads

Microsoft SQL Server 2000 Scalability Project

This white paper is a joint effort by Microsoft and Dell to demonstrate the scalability of SQL Server 2000 and Dell hardware.   Read more...
By Additional Articles 2002/01/10 | Source: Microsoft MSDN | Category: administration
Rating:  Rate this |   Briefcase | 990 reads

Common SQL Server and Windows Clustering Questions and Problems

This article covers some of the common issues and questions when you cluster SQL Server 2000 and Windows 2000.   Read more...
By Brian Knight 2001/10/11 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 12,335 reads

INF: Understanding How to Configure a SQL Server Connection Affinity

In an online transaction processing (OLTP) environment, the connection affinity mask option may provide performance enhancement in high-end, enterprise-level SQL Server environments that are running on computers with 16 or more CPUs. In particular, this option is useful when there are a significant number of network interactions (more than 10,000 per second) between the middle-tier application servers and the back-end SQL Server system.   Read more...
By Additional Articles 2001/08/28 | Source: ASPToday | Category: administration
Rating:  Rate this |   Briefcase | 1,176 reads
<< Newer    Items 21 to 25 of 25   
 
Tags
configuring (9)    
miscellaneous (7)    
t-sql (7)    
monitoring (3)    
backup / restore (2)    
distributed queries (2)    
indexing (2)    
programming (2)    
replication (2)    
stored procedures (2)    
strategies (2)    
advanced querying (1)    
analysis services (ssas) (1)    
data warehousing (1)    
database design (1)    
dts (1)    
english query (1)    
installation (1)    
naming standards (1)    
olap server (1)    
openxml (1)    
security (1)    
triggers (1)    
updategrams (1)    
user defined function (udf) (1)    
xml (1)    
xsl (1)