goto Indian Health Service home page Indian Health Service: The Federal Health Program for American Indians and Alaska Natives

 
Advanced  Search
IHS HOME ABOUT IHS SITE MAP HELP
goto Health and Human Services home page goto Health and Human Services home page
TOC\ Computers & Internet\ Software\ Database Software\ MS SQL Server\ SQL Server Performance Tuning 
SEARCH Links
      Databases@
      Performance Tuning & Optimizing@
       Web Development Resources@
Defusion: A Beginner's Guide to Speed and Stability with SQL Server  - In MS Access, what can be an extremely complicated chore is made quite simple through point and click functionality, many developers do not realize that a SQL Server database takes a lot more effort to manage successfully than MS Access.   URL: http://www.defusion.com/db_techniques/Issue4/db_article_2.cfm
Index Tuning Wizard for SQL Server 7.0  - Choosing the right set of indexes for a data-intensive application, such as a data warehouse or decision support database, is crucial for performance. When designing a database, administrators usually handpick the indexes, a time-consuming process. For years, they have sought a method to automate index selection. With the Index Tuning Wizard, Microsoft SQL Server 7.0 offers a solution that also ensures competitive results. This white paper illustrates why automated index selection is notoriously difficult to develop and explains how to use the Index Tuning Wizard to automate and customize index selection.   URL: http://www.microsoft.com/sql/70/whpprs/indexwp.htm
MS SQL Server 7.0 Performance Tuning Guide  - Provides database administrators and developers with valuable information on Microsoft SQL Server 7.0 index selection, disk I/O subsystem tuning, and SQL Server 7.0 performance tuning tools. (48 printed pages)   URL: http://www.microsoft.com/sql/70/whpprs/perftun.htm
Optimizing SQL Server Performance  - Experience has shown that the greatest benefit in SQL Server performance can be gained from the general area of logical database design, index design, and query design. Conversely, the biggest performance problems are often caused by deficiencies in these areas. If performance is a concern, it is wise to concentrate on these areas first, since very large performance improvements can often be achieved with a relatively small time investment. While other performance issues such as memory, cache buffers, hardware, etc., are certainly candidates for study, experience has shown that the performance gain from these areas is often of an incremental nature.   URL: http://www.tiac.net/users/sqltech/document/optimize.htm
SQL Server 7.0 Query Processor  - This document states the goals of SQL Server 7.0, explains SQL data query processing, and discusses specific improvements to the SQL Server 7.0 query processor. Included in this document: Goals for Microsoft SQL Server 7.0; Query Execution; Query Optimization; Distributed Queries; Working with Queries.   URL: http://www.microsoft.com/sql/70/whpprs/Upgrade.htm
SQL Server Database Performance Tuning And Optimization Articles  - SQL Server Articles and Tutorials. A Source for Microsoft SQL Server Performance Tuning and Optimization. Over 175,000 words of SQL Server performance tuning content!   URL: http://www.sql-server-performance.com/articles.asp
If you need a plugin or viewer to view a file, click here.
 
Links Home | Login

Accessibility  --  Disclaimers  --  Website Privacy Policy  --  Freedom of Information Act
Kids Page  --  No Fear Act  --  Frequently Asked Questions  --  USA.gov  --  HHS