SQL Server Magazine September 2000
[Focus]
Which XML features are in SQL Server 2000 and not in Microsoft's XML technology preview--and vice versa? This article guides you through the versions' different XML implementations.
By Bob Beauchemin
[Features]
Use SQL Server’s built-in COM automation environment to automate COM objects from within stored procedures and integrate SQL Server with other systems.
By James T. Stanley
Results from an OLAP cube performance study reveal steps you can take to optimize the performance of multidimensional databases.
By Rajiv Tewari
In the second article of a three-part series, the authors show you how to query distributed partitioned views in SQL Server 2000.
By Kalen Delaney , et al.
[Lab Reports]
Armed with a new interface and other enhancements, Embarcadero's data modeling tool is poised to go head-to-head with market leader PLATINUM ERwin/ERX.
By Ron Talmage
[SQL Server Savvy]
Learn about translating image data types to integers, configuring services to be dependent on SQL Server, determining the fastest way to load data, and starting column names with numbers.
By Brian Moran
[Editorial]
Shared-nothing clustering pushes SQL Server 2000 over the top.
By Michael Otey
[Reader to Reader]
A reader shares his tip for using Excel's SQL.REQUEST function.
By Various Authors
[SQL Server Q&A]
Richard Waymire answers questions about comparing grid and text mode performance, determining SQL Server memory usage, and more.
By Richard Waymire
[SQL Seven]
Senior technical editor Michael Otey highlights seven recent Knowledge Base articles about SQL Server.
By Michael Otey
[SQL Server/Office Integration]
The author demonstrates two approaches to programming custom filters for the SQL Server Pubs database with Access forms.
By Rick Dobson
[Inside SQL Server]
Kalen Delaney sheds light on the most misunderstood data type.
By Kalen Delaney
[Mastering Analysis]
Russ Whitney demystifies the data-mining features of Analysis Services.
By Russ Whitney
[Solutions by Design]
This last installment in Michelle A. Poolet's data-modeling series defines seven steps for bringing your database to life.
By Michelle A. Poolet
[T-SQL Black Belt]
You can rewrite logical expressions to leverage the short circuit feature, which saves CPU cycles and prevents runtime errors.
By Itzik Ben-Gan
[News Analysis]
Oracle took some heat this summer after hiring a private detective agency to dig up dirt about Microsoft during the Microsoft antitrust trial.
By Paul Thurrott
The Transaction Processing Performance Council (TPC) has overturned the TPC-C and TPM-C benchmark records that SQL Server 2000 set in February 2000, citing a noncompliance issue that Microsoft rival Oracle discovered.
By Paul Thurrott
|
