SQL Server Magazine May 2002
[Focus]
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.
By Kalen Delaney
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.
By Itzik Ben-Gan
[Features]
Are performance-sapping bottlenecks weighing down your snapshot replication environment? Here's how to optimize snapshot replication for large databases.
By Herts Chen
[SQL Server Savvy]
A reader asks how to create a T-SQL query that counts the number of times a word displays in a record.
By Brian Moran
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?
By Brian Moran
[Editorial]
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.
By Michael Otey
[Reader to Reader]
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.
By Readers
A reader explains how to use two undocumented extended stored procedures to examine error logs.
By Readers
[SQL Seven]
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.
By Michael Otey
[Inside SQL Server]
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.
By Kalen Delaney
[Mastering Analysis]
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.
By Russ Whitney
[Solutions by Design]
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.
By Michelle A. Poolet
[T-SQL Black Belt]
Test your T-SQL skills (and create cool wallpaper) by creating code that randomly generates abstract patterns to certain specifications.
By Itzik Ben-Gan
[Answers from Microsoft]
Microsoft’s SQL Server development team provides code to illustrate the best way to append an IDENTITY column to a temporary table.
By Microsoft's SQL Server Development Team
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.
By Microsoft's SQL Server Development Team
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.
By Microsoft's SQL Server Development Team
Microsoft’s SQL Server development team describes two ways to replicate changes between a flat-file system and a SQL Server database.
By Microsoft's SQL Server Development Team
The Microsoft SQL Server development team provides sample code for a stored procedure that transfers data from a text file to SQL Server.
By Microsoft's SQL Server Development Team
[Letters]
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."
By Various Authors
[New Products]
Check out these new and enhanced products.
By Carolyn Mader , et al.
|
