SQL Server Magazine

		Options
Monitoring SQL Server See what's new in SQL Server 2000 Profiler, an invaluable investigative tool that lets you measure query performance, debug applications, diagnose problems, and replay saved traces. Then, learn when and how to use SQL Server's server-side tracing functionality.		• Subscribe • Renew • Master CD • Change Mailing Address • Customer Service • Back Issues • Article Reprints • Group Discounts
Browse Archived Articles By: Issue | Author | Subject | Department |

Tracking Down Event Clues

SQL Server 2000 divides its tracing functionality into two separate but connected components: SQL Trace on the server and SQL Profiler on the client. Learn how and when to use server-side traces.
By Kalen Delaney 

What's New in SQL Server 2000 Profiler

Enhancements in SQL Server 2000's Profiler let you thoroughly and efficiently trace server activity.
By Itzik Ben-Gan 

Doing DBA Chores with SQL-DMO

DBAs need all the tricks and tools they can find to perform their duties. Using SQL-DMO objects in VBScript files should be an important part of every DBA’s toolkit.
By Kevin Christensen 

Problem Children

SQL Server data types (including integer, character, numeric, datetime, and uniqueidentifier) can behave in surprising ways. Keep them in check with these tips.
By Wayne Snyder 

Transactional Replication Without the Snapshot Agent

If the process of synchronizing databases exceeds your maintenance window, try this technique for using transactional replication without the Microsoft Snapshot Agent.
By Cedric Britt  , et al.

Questions, Answers, and Tips

SQL Server MVP Brian Moran answers readers' questions.
By Brian Moran 

Overdue Diligence

SQL Server lets you accept all the default installation settings and just walk away—with an installation that's less than reliable. Make sure you do your part to make SQL Server as secure and reliable as possible.
By Michael Otey 

Answers from Microsoft

Richard Waymire tells readers how to append extra characters to a fixed-character column, how to troubleshoot fluctuations in backup tape speed, and more.
By Richard Waymire 

Tapping In to Windows 2000

Here are Michael Otey's selections for the top seven Win2K improvements from a SQL Server perspective.
By Michael Otey 

Creating Tables with SQL-DMO

Develop your basic SQL-DMO programming skills by creating tables in Access projects.
By Rick Dobson 

More Fill-Factor Mysteries

The SQL Server sleuth tracks down the truth about fill factor and page splitting.
By Kalen Delaney 

Filtering and Sorting in ASP

Trim your workload, streamline your site, and wow your visitors by using ASP to develop your Web pages.
By Ken Spencer 

Distinct Count Queries

The kinds of questions that distinct count queries can answer are useful in analyzing retail product sales. Distinct count queries can also apply in other areas. Find out how to use MDX to answer them.
By Russ Whitney 

Metamodel for Retail Sales

Create a customizable entity relationship (ER) template for your complex database designs.
By Michelle A. Poolet 

Adding Performance

Use mathematics to reduce the code necessary to solve your business problems.
By Itzik Ben-Gan 

BackOffice Server 2000 Targets Midsized Businesses

The new MultiServer mode that lets users distribute applications across as many as three servers leads the BackOffice Server 2000 features that address the needs of midsized businesses with more than 50 PCs.
By Paul Thurrott 

SQL Server 2000 Wins Top Awards

Datamation and eWEEK award SQL Server 2000 their highest honors for data warehousing, business intelligence (BI), and enterprise systems development.
By Paul Thurrott 

SQL Server Bests High-End Records

SQL Server 2000 mounts a challenge to the premium-priced UNIX platform with record-breaking performance results on a Windows 2000 Datacenter-based Unisys ES7000 machine.
By Paul Thurrott 

XML Q&A

Rich Rollman answers questions about expanding a hierarchy by using self-referential columns and about how to store an exact decimal value in a real or float column.
By Rich Rollman