SQL Server Magazine May 2001
[Focus]
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
Enhancements in SQL Server 2000's Profiler let you thoroughly and efficiently trace server activity.
By Itzik Ben-Gan
[Features]
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
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
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.
[SQL Server Savvy]
SQL Server MVP Brian Moran answers readers' questions.
By Brian Moran
[Editorial]
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
[SQL Server Q&A]
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
[SQL Seven]
Here are Michael Otey's selections for the top seven Win2K improvements from a SQL Server perspective.
By Michael Otey
[SQL Server/Office Integration]
Develop your basic SQL-DMO programming skills by creating tables in Access projects.
By Rick Dobson
[Inside SQL Server]
The SQL Server sleuth tracks down the truth about fill factor and page splitting.
By Kalen Delaney
[Web Dev]
Trim your workload, streamline your site, and wow your visitors by using ASP to develop your Web pages.
By Ken Spencer
[Mastering Analysis]
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
[Solutions by Design]
Create a customizable entity relationship (ER) template for your complex database designs.
By Michelle A. Poolet
[T-SQL Black Belt]
Use mathematics to reduce the code necessary to solve your business problems.
By Itzik Ben-Gan
[News Analysis]
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
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 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
|
