By Russ Whitney, 08/11/2000
The FoodMart 2000 database includes a virtual cube called Trained Cube, with a data-mined dimension called Customer Pattern.
By Russ Whitney, 08/11/2000
Suppose you’re developing an application that must provide users access to large amounts of information and you decide the best method is to display the data one page at a time (a ...
By Rajiv Tewari, 08/11/2000
A well-designed data warehouse provides users fast, easy-to-use, and efficient analytical capabilities for a large body of data.
By James T. Stanley, 08/11/2000
SQL Server's sp_OAGetErrorInfo stored procedure provides all the information you need to pass up to your application's middle and client tiers when an error occurs.
By James T. Stanley, 08/11/2000
T-SQL's data types don’t map one-to-one with data types in other programming languages.
By Bob Beauchemin, 08/11/2000
Microsoft's XML technology preview's functionality consists of an Internet Service API (ISAPI) application, sqlxml.dll, that accepts SQL Server input in special XML formats.
By Paul Thurrott, 08/11/2000
Microsoft's problems with the Transaction Processing Performance Council (TPC) notwithstanding, another rival eclipsed Microsoft’s TPC-C record without any help from Oracle.
By Paul Thurrott, 08/11/2000
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, 08/11/2000
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 ...
By Richard Waymire, 07/26/2000
Richard Waymire answers questions about comparing grid and text mode performance, determining SQL Server memory usage, and more.
By Bob Beauchemin, 07/20/2000
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 ...
By Russ Whitney, 07/19/2000
Russ Whitney demystifies the data-mining features of Analysis Services.
By Ron Talmage, 07/18/2000
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 James T. Stanley, 07/17/2000
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 Itzik Ben-Gan, 07/17/2000
You can rewrite logical expressions to leverage the short circuit feature, which saves CPU cycles and prevents runtime errors.
By Kalen Delaney, 07/17/2000
Kalen Delaney sheds light on the most misunderstood data type.
By Michelle A. Poolet, 07/17/2000
This last installment in Michelle A. Poolet's data-modeling series defines seven steps for bringing your database to life.
By Rajiv Tewari, 07/14/2000
Results from an OLAP cube performance study reveal steps you can take to optimize the performance of multidimensional databases.
By Brian Moran, 07/13/2000
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 ...
By Various Authors, 07/13/2000
A reader shares his tip for using Excel's SQL.REQUEST function.
By Itzik Ben-Gan, 07/05/2000
In the second article of a three-part series, the authors show you how to query distributed partitioned views in SQL Server 2000.
By Michael Otey, 07/05/2000
Shared-nothing clustering pushes SQL Server 2000 over the top.
By Rick Dobson, 06/26/2000
The author demonstrates two approaches to programming custom filters for the SQL Server Pubs database with Access forms.
By Michael Otey, 06/26/2000
Senior technical editor Michael Otey highlights seven recent Knowledge Base articles about SQL Server.