SQL Server Magazine

		Options
Performance Tuning See how you can optimize queries and query execution with improved indexes, joins, and disk access, and how to take advantage of new Query Analyzer features. And learn how you can optimize performance with the successor to SQL Trace in SQL Server 7.0's integrated event model		• Subscribe • Renew • Master CD • Change Mailing Address • Customer Service • Back Issues • Article Reprints • Group Discounts
Browse Archived Articles By: Issue | Author | Subject | Department |

New Features for Query Processing

The query processor is one of the most important database system components that influence the management of large databases. SQL Server 7.0's focus is on new techniques for maximizing your query performance.
By Dusan Petkovic  , et al.

SQL Server Snap-In Management

SQL Server 7.0 uses the Microsoft Management Console (MMC) to host its Enterprise Manager, the primary tool for managing SQL Server.
By Ken Spencer 

The DTS Development Guide

Do you have a DTS question about error handling, package execution, extensibility, or data-driven queries? You're not alone. Let our experts help!
By Don Awalt  , et al.

Using SQL Profiler

The new SQL Profiler utility lets you monitor, analyze, and tune SQL Server 7.0.
By Paul Burke 

Querying & Reporting: Generate Reports with Word

How to use Visual Basic (VB) and Word to create custom reports from a SQL Server database using COM objects with Microsoft Office applications.
By Ken Spencer 

SQL By Design: The Circular Reference

An analysis of a poor design construct called the circular reference, a recursive condition, where one table references a second table, which in turn references the first table.
By Michelle A. Poolet 

T-SQL for Starters: Simple and Correlated Subqueries

A correlated subquery can drastically affect query performance and in some cases, you can replace subqueries with joins for more efficient code. I examine both simple and correlated subqueries and explain why.
By Michael D. Reilly 

Trends & Insights: Getting Help with SQL Server

Some helpful resources to help you see how people are using SQL Server.
By Karen Watterson 

Cyberprise Enterprise Edition

Web integration, which can mean publishing internal documents and company news across an intranet, providing a public presence on the Internet, and building data-driven Web site applications, is a challenge most businesses face.
By Michael Otey 

SQL Insider: Support, Visualization, Verticals, and Visions

Microsoft's new support options are here.
By Hugh Willoughby-Davis 

The Numbers Game

Will the real NT database leader please stand up?
By Michael Otey 

Defining Tables, Exporting Diagrams, and More

Microsoft answers your questions.
By Richard Waymire 

Data-Access APIs

Here's a look at SQL Server's seven primary client data-access methods.
By Michael Otey 

SQL Server 7.0 Locking

A look at SQL Server 7.0's locking modes, the resources that SQL Server can lock, and a simple tool for observing the active locks.
By Kalen Delaney 

Shaped Recordsets

Learn to use the SHAPE statement to create recordsets for hierarchical retrieval.
By Ken Spencer 

Mastering OLAP: Why Bother?

This month we stray from MDX query basics as we try to explain why OLAP is such a hot technology.
By Brian Moran  , et al.