---

[Focus]

---

All About Restore
Recovery often receives less attention than backup, but restoring your database after a disaster is one of the most important jobs you do. Review the basics, and start developing--and testing-- your recovery plan right away.
 — Kalen Delaney


Effective Installation
Installing SQL Server 2000 is deceptively simple--choosing the wrong options can lead to big headaches later. These detailed instructions will help you make the right decisions.
 — Itzik Ben-Gan

---

[Features]

---

Bottleneck Blues
Are performance-sapping bottlenecks weighing down your snapshot replication environment? Here's how to optimize snapshot replication for large databases.
 — Herts Chen

---

[SQL Server Savvy]

---

Counting Instances of a Word in a Record
A reader asks how to create a T-SQL query that counts the number of times a word displays in a record.
 — Brian Moran


Row Count and Memory Utilization
How can you create a SQL query that lists the top 10 largest table in a database and displays how many rows and total bytes each table uses?
 — Brian Moran

---

[Editorial]

---

"Little" Design Mistakes
One of the most common mistakes in database and software design is thinking and testing too small. So think big to avoid unpleasant and unnecessary application rollout problems.
 — Michael Otey

---

[Reader to Reader]

---

Scheduling the Log Reader Agent
A reader shares a tip for alleviating your SQL Server's processor load by scheduling the Log Reader Agent instead of letting it run continuously.
 — Readers

View Error Logs
A reader explains how to use two undocumented extended stored procedures to examine error logs.
 — Readers

---

[SQL Seven]

---

Query Analyzer Shortcuts
Query Analyzer is one of the most frequently used utilities in SQL Server’s tool set. Here are seven keyboard shortcuts that make Query Analyzer a more effective and productive tool.
 — Michael Otey

---

[Inside SQL Server]

---

The Best Indexes for Joins
You've tuned your indexes to optimize single-table queries, but how do you find the best indexes to help your JOIN queries run faster? Test and test again.
 — Kalen Delaney

---

[Mastering Analysis]

---

OLAP: More Than Numbers
Some of the most valuable OLAP solutions don't start with numeric information. You can analyze any database--with or without numeric information--by using counts.
 — Russ Whitney

---

[Solutions by Design]

---

Music Collection Revisited
Once more, with feeling: In response to a reader’s suggestion, Michelle Poolet revises the database model for a music CD collection to include storage-location data.
 — Michelle A. Poolet

---

[T-SQL Black Belt]

---

In the Picture
Test your T-SQL skills (and create cool wallpaper) by creating code that randomly generates abstract patterns to certain specifications.
 — Itzik Ben-Gan

---

[Answers from Microsoft]

---

Appending an IDENTITY Column to a Temporary Table
Microsoft’s SQL Server development team provides code to illustrate the best way to append an IDENTITY column to a temporary table.
 — Microsoft's SQL Server Development Team


Changing Code Page from SQL Server 7.0 to SQL Server 2000
Microsoft’s SQL Server development team explains why the SQL Server 2000 code page for default installation is different from the SQL Server 7.0 code page.
 — Microsoft's SQL Server Development Team


Recompilation and Coding Owner Prefixes on a Stored Procedure
Microsoft’s SQL Server development team explains why you shouldn’t be concerned about recompilation when you attach an owner prefix to a stored procedure and qualify a table or view.
 — Microsoft's SQL Server Development Team


Replicating Data Between a Flat-File System and SQL Server
Microsoft’s SQL Server development team describes two ways to replicate changes between a flat-file system and a SQL Server database.
 — Microsoft's SQL Server Development Team


Using a Stored Procedure to Transfer Data from a Text File to SQL Server
The Microsoft SQL Server development team provides sample code for a stored procedure that transfers data from a text file to SQL Server.
 — Microsoft's SQL Server Development Team

---

[Letters]

---

Letters, May 2002
A reader asks about selecting a clustered index so that inserts are scattered throughout a table, as Morris Lewis suggested in his March 2002 article, "Feng Shui and Database Design."
 — Various Authors

---

[New Products]

---

New Products, May 2002
Check out these new and enhanced products.
 — Carolyn Mader , et al.