SQL Server Magazine July 2000
[Focus]
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 John D. Lambert
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 Subscribers back to the Publisher.
By Baya Pavliashvili
[Features]
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, robust corporate applications and Web sites.
By David Jones
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, then use triggers and T-SQL queries to manage that data.
By Itzik Ben-Gan
Learn how to use SQL Server 2000's new methods of enforcing referential integrity in your databases.
By Kalen Delaney
[SQL Server Savvy]
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 Configuration Utility installed, and more.
By Brian Moran
[Editorial]
Scaling out might be a viable solution for database implementations that have reached the limits of SMP scalability.
By Michael Otey
[Reader to Reader]
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 Manager, and more.
By Various Authors
[SQL Server Q&A]
A Microsoft program manager answers your SQL Server questions.
By Richard Waymire
[SQL Seven]
Michael Otey lists his favorite SQL Server white papers, all of which you can find on Microsoft’s Web site.
By Michael Otey
[SQL Server/Office Integration]
Learn how to build a custom application with Access projects and SQL Distributed Management Objects (SQL-DMO).
By Rick Dobson
[Inside SQL Server]
SQL Server 2000 brings you the long-awaited capability to run multiple SQL Server installations on one machine.
By Kalen Delaney
[Web Dev]
A new feature of COM+—queued components—offers benefits to developers of Web applications on the SQL Server platform.
By Ken Spencer
[Solutions by Design]
Working from the concept model, take the next step in database design and manually create a logical model of your database.
By Michelle A. Poolet
[T-SQL Black Belt]
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 Itzik Ben-Gan
[Mastering OLAP]
A new Analysis Services feature, called actions, can link structured or unstructured data or commands to almost any part of an OLAP cube.
By Russ Whitney
|
