SQL Server Magazine April 2000
| |
|
Options |
SQL Server Performance Tools
Track down database performance problems with SQL Server 7.0's impressive arsenal of tools: SQL Profiler, the Flight Recorder, and the Index Tuning Wizard. SQL Server MVP Itzik Ben-Gan shows you how to use the Profiler tool to define a trace, how to use the Flight Recorder function to trace the last 100 queries processed, and how to use the Index Tuning Wizard to analyze queries against the database.
|
|
• Subscribe
• Renew
• Master CD
• Change Mailing Address
• Customer Service
• Back Issues
• Article Reprints
• Group Discounts
|
|
[Focus]
Like magic, the ITW analyzes queries run against your database and recommends which indexes to create.
By Itzik Ben-Gan
Put SQL Server 7.0's tracing functions to work investigating everything from long-running queries to deadlocks.
By Itzik Ben-Gan
Get started with SQL Server 7.0's powerful tracing architecture by learning how to use the graphical Profiler tool to define a trace. Also, use the Flight Recorder function to trace the last 100 queries processed.
By Itzik Ben-Gan
[Features]
Is ColdFusion the right Web development environment for you? This overview of how ColdFusion works can help you decide.
By T.J. Harty
Horizontally partitioned views can improve query performance and help you maintain high data availability with low overhead cost.
By Claude Seidman
Build high-performing, interactive Web-based solutions on the familiar client/server model for data access.
By Dino Esposito
[Editorial]
A recent study by Zona Research revealed that more Web servers access SQL Server than any other database. Here's how to implement simplicity, scalability, and security for your Web-based databases.
By Michael Otey
[Reader Challenge]
Find out how to move database log files with minimal downtime.
By Tibor Karaszi
[Reader to Reader]
ActiveX controls simplify replication for remote users.
By David Leibowitz
[SQL Server Q&A]
Richard Waymire answers readers' questions about installing SQL Server desktop edition, creating user-defined functions, and more.
By Richard Waymire
[SQL Seven]
A list of some of the best sites on the Web for Visual Basic (VB).
By Michael Otey
[SQL Server/Office Integration]
Learn by example by using stored procedures from Books Online with Access projects.
By Rick Dobson
[Inside SQL Server]
Use these SQL Server 7.0 features to access meta data.
By Kalen Delaney
[Web Dev]
Create a reusable ASP script that you can reuse for many data-management purposes.
By Ken Spencer
[Mastering Analysis]
Progress through the levels of Multidimensional Expression (MDX) mastery to harness this language's power.
By Russ Whitney
[Solutions by Design]
Build a more effective database by constructing a data model.
By Michelle A. Poolet
[Special Reports]
This supplement highlights business management applications that run on the Microsoft BackOffice platform. This .pdf file requires Adobe Acrobat. Visit Adobe to download the reader.
By Stewart McKie
|
