By Michelle A. Poolet, 06/13/2000
Portable data types are those that you can translate into any database vendor's set of physical data types without loss of meaning, content, or value.
By David Jones, 06/13/2000
Suppose you want a table to hold all content for your dynamically populated Web site.
By Russ Whitney, 06/13/2000
How would you write a query on the FoodMart 2000 Sales cube that returns the unit sales?
By Russ Whitney, 06/13/2000
Use the FoodMart Sales or FoodMart 2000 Sales cube to answer the following question:
By Russ Whitney, 06/13/2000
Actions are a new feature of Analysis Services that can link more detailed information to an OLAP cube.
By Ken Spencer, 05/24/2000
A new feature of COM+—queued components—offers benefits to developers of Web applications on the SQL Server platform.
By David Jones, 05/23/2000
Implement SQL Server 7.0’s full-text search capabilities to avoid time-consuming table scans, enable advanced pattern matching, and deliver quick results in high-performance, ...
By Brian Moran, 05/22/2000
Read about SQL Server 2000's new cascading Declarative Referential Integrity support, how to change default client-side Netlib settings when you don't have the SQL Server Client ...
By Itzik Ben-Gan, 05/22/2000
SQL Server doesn't inherently support hierarchies, such as those between employees and managers, but you can add columns to your database tables to hold hierarchical information, ...
By Baya Pavliashvili, 05/22/2000
With SQL Server 7.0's immediate-updating subscription feature, not only can you can replicate changes from a Publisher to Subscribers, but you can replicate changes on the ...
By Itzik Ben-Gan, 05/22/2000
In the debut T-SQL Black Belt article, SQL Server MVP Itzik Ben-Gan demonstrates how you can use joins and subqueries to modify a table based on data in another table.
By Rick Dobson, 05/19/2000
Learn how to build a custom application with Access projects and SQL Distributed Management Objects (SQL-DMO).
By Michael Otey, 05/19/2000
Michael Otey lists his favorite SQL Server white papers, all of which you can find on Microsoft’s Web site.
By Michelle A. Poolet, 05/17/2000
Working from the concept model, take the next step in database design and manually create a logical model of your database.
By Richard Waymire, 05/16/2000
A Microsoft program manager answers your SQL Server questions.
By John D. Lambert, 05/11/2000
Using T-SQL to develop custom stored procedures for copying data gives you maximum flexibility in a method that combines features of snapshot and transactional replication.
By Russ Whitney, 05/11/2000
A new Analysis Services feature, called actions, can link structured or unstructured data or commands to almost any part of an OLAP cube.
By Michael Otey, 05/10/2000
Scaling out might be a viable solution for database implementations that have reached the limits of SMP scalability.
By Various Authors, 05/08/2000
Readers share their tips for finding and inserting missing records, for using cursors to perform operations on multiple objects, for expanding the Databases node in Enterprise ...
By Kalen Delaney, 05/04/2000
Learn how to use SQL Server 2000's new methods of enforcing referential integrity in your databases.
By Kalen Delaney, 05/04/2000
SQL Server 2000 brings you the long-awaited capability to run multiple SQL Server installations on one machine.