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

Content with tags Performance Tuning, Miscellaneous, Administration Rss

   Items 1 to 8 of 8   
 

SQL Maintenance Plans

Do you use the maintenance plans or hate them? Wish they would do more? Curious about how they work under the hood? Cmon, you gotta read this one! Trust us, it's not another "how-to" article! Well, maybe just a little bit!   Read more...
By Andy Warren 2005/03/04 (first published: 2002/04/11) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 33,814 reads

Importing And Analyzing Event Logs

Another new author! Gheorge shares some ideas about importing event logs and using OLAP to analyze the results. Not a bad idea at all. How many of use OLAP as often as we should? Read the article, see if it's something you want to try - and let Gheorge know what you think!   Read more...
By Gheorghe Ciubuc 2003/05/28 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 12,779 reads

Economies of Speed Whitepaper

Seagate has a white paper out that discusses how faster (15k rpm) drives can lead to lower cost of ownership. Interesting, and worth looking into.   Read more...
By Additional Articles 2003/05/08 | Source: Other | Category: administration
Rating:  Rate this |   Briefcase | 1,156 reads

Auto Close and Auto Shrink - Just Don't

New author! Mike Pearson discusses how auto close was at the root of a performance problem he was troubleshooting, how you can check your servers easily, and discusses why both auto close and auto shrink are bad ideas in a production environment.   Read more...
By Mike Pearson 2003/05/05 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 19,923 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

SQL Maintenance Plans

Do you use the maintenance plans or hate them? Wish they would do more? Curious about how they work under the hood? Cmon, you gotta read this one! Trust us, it's not another "how-to" article! Well, maybe just a little bit!   Read more...
By Andy Warren 2005/03/04 (first published: 2002/04/11) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 33,814 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 | 1,714 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,500 reads
   Items 1 to 8 of 8   
 
Tags
sql server 7 (7)    
configuring (6)    
t-sql (3)    
distributed queries (2)    
indexing (2)    
monitoring (2)    
programming (2)    
replication (2)    
analysis services (ssas) (1)    
backup / restore (1)    
data warehousing (1)    
dts (1)    
english query (1)    
installation (1)    
olap server (1)    
openxml (1)    
security (1)    
stored procedures (1)    
strategies (1)    
triggers (1)    
updategrams (1)    
user defined function (udf) (1)    
xml (1)    
xsl (1)