The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
In this issue, learn how linked servers can bring your SQL Server and Oracle databases together, how to put data mining to work for your company, how to use XML to build a search application for Web and WAP browsers, and more!
By Itzik Ben-Gan
Forget cursors. The key to a successful switch to set-based programming is to test several approaches and optimize, optimize, optimize.
By Michelle A. Poolet
Design a metamodel for scheduling a company’s employees and their work, workplaces, and work shifts.
By Michael Otey
A one-size-fits-all approach to application implementation certainly requires less expense up front, but it comes with its own—and possibly much higher—cost in the long run.
By Rich Rollman
Rich Rollman describes three techniques for detecting updategram errors.
By Russ Whitney
The November puzzle challenges you to write a query that will help you analyze the effectiveness of retail promotions.
By William Sheldon
Windows Installer and a set of VBScript and T-SQL scripts deliver a one-two punch for custom-installing your SQL Server databases.
By John Paul Cook
Learn how to deal with differences in how SQL Server and Oracle treat transaction commitment.
By Kamal Hathi
Learn some common data-mining terminology.
By Richard Waymire
Richard Waymire answers a reader’s question about dependency tracking.
To fully analyze an Oracle linked-server query, you need to use Oracle's SQL Trace facility.
By
Readers submit an alternative solution for retrieving specified rows within a resultset and request continuing OLAP coverage.
Richard Waymire answers a reader’s question about resetting the password for the SQL Server and SQL Server Agent services.
Richard Waymire tells a reader how to replace the Named Pipes Net-Library.
Linking servers is fairly straightforward when they're all SQL Servers--but what happens when your company has data in both SQL Server and Oracle? Here's a guide to what Microsoft and Oracle don't tell you.
By Brian Moran
To use table variables in a join, you must first alias the local table variable. Here's how.
Learn how to use Profiler to display information about queries that Enterprise Manager generates.
Learn how to write an MDX query that returns an ordered list of retail product options.
You can't use a linked server to execute an Oracle stored procedure from SQL Server, but you can update an Oracle table from a linked-server query.
By Wei-Meng Lee
SQL Server 2000’s XML support is not only cool but practical. Here’s an example of how you can use it to build a search application for Web and WAP browsers.
Some SQL Server system stored procedures can help you obtain Oracle metadata from a linked Oracle server.
Richard Waymire helps a reader retrieve existing DDL information for rows in a new SQL Server 2000 table.
Extended properties are great for managing metadata in SQL Server environments.
Richard Waymire answers a reader’s question about estimating the time a query will run.
The number of users who work remotely is growing, but most analytic applications don't work without a network connection. Here's a way to give mobile users access to the specific data they need.
Query Analyzer provides a simple but relatively unknown mechanism for working with properties.
Use these SQL Server-specific performance counters to keep tabs on your system's response to gradual load changes.
The data-mining features in SQL Server 2000 Analysis Services can help your organization find the patterns and rules to improve its marketing, sales, and customer-support operations and gain a better understanding of its customers.
Richard Waymire tells a reader how to work around a failed installation of SQL Server 7.0 SP2.
Richard Waymire helps a reader use SQL-DMO to test a connection between VB and SQL Server.
Learn how SQL Server orders data when you try to sort by a column which is defined with a uniqueidentifier data type.
Richard Waymire answers a reader’s question about sa mapping to DBO.
advertisement