SQL Server Maintenance
Clustering
SQL Server 2000 Failover Clustering
Federated SQL Servers
Designing Federated Database Servers
Indexes
Creating an Index
Clustered Indexes
Using Clustered Indexes
Indexing Dos and Don’ts
Index Creation Guidelines
How To: Optimize SQL Indexes
Reading Execution Plans in SQL Server 2000
SQL Server Performance Questions & Answers
Creating and Modifying PRIMARY KEY Constraints
SQL Server Index Fragmentation and Its Resolution
Understanding Indexes (Chapter 21: SAMS Publishing)
SQL Server 2000 Design and Implementation, Part V - Creating and Maintaining Indexes...
Index Tuning Wizard
Index Tuning Wizard for Microsoft SQL Server 2000
Managing Index Fragmentation
DBCC DBRE INDEX
Microsoft SQL Server 2000 Index Defragmentation Best Practices
MCSE/MCDBA Exam Study
Chapter 3: Physical Database Design and Implementation.pdf
Other Maintenance Related Articles
Managing the DTC Service Remotely
SSW Rules to Better SQL Server Databases
Keep SQL Server Up and Running
Shutting Down SQL Server
Starting, Pausing, and Stopping SQL Server
Creating Logins for Databases Restored to a Replacement SQL Server
sp_addlogin
31 SQL Server Tips That Can Save Your Butt
Using OPENXML
Getting the Wrong Identity in Microsoft SQL Server identity Columns?
More Trees & Hierarchies in SQL
3.5.4 The Rows Holding the Group-wise Maximum of a Certain Field
Codd's 12 Rules
Reserved Keywords
Tips on Writing Portable SQL Code
Date Functions
Generate Test Data Quickly With Cross Joins
Cold Fusion Functions
Calculating Running Totals
CAST and CONVERT
Reserved Words for Various Databases
Key Issues
Transact-SQL Cursors
Permissions
GRANT
DENY
Performance Tuning
SQL Server Profiler Tips
SQL Server Scalability FAQ
Checklist: SQL Server Performance
Chapter 14 — Improving SQL Server Performance
SQL Server Database Index Performance Checklist
Microsoft SQL Server 7.0 Performance Tuning Guide
Inside SQL Server 2000's Memory Management Facilities
How to configure memory for more than 2 GB in SQL Server
Microsoft SQL Server Performance Tuning and Optimization
SQL Server 7.0 Resource Guide > Chapter 6 - Performance Tuning
Chapter 20 - RDBMS Performance Tuning Guide for Data Warehousing
How to Take Advantage of SQL Server 2000 Performance Tuning Tools
How to Collect and Analyze Performance Data in Microsoft SQL Server (WebCast)
Support Web Cast: SQL Server 2000 Profiler: What's New and How to Effectively Use It
Scripts
SQL Server Central's: Script Library
Troubleshooting & Monitoring
Monitoring Server Performance and Activity
Q224587 INF: Troubleshooting Application Performance with SQL Server
Q243586 INF: Troubleshooting Stored Procedure Recompilation
Q283696 Job to Monitor SQL Server 2000 Performance and Activity
Q283784 How to View SQL Server 2000 Activity Data
Back to Mike Beaver's Hypnotherapy Home Page