Microsoft has expanded the information about expanding hierarchies in SQL Server Books Online (BOL) since SQL Server 6.x. But the BOL solution merely displays the output; you can’t join the results with other views, tables, or results. My T-SQL coding solution fills this gap. Also, the solution I pr

SQL Server Magazine presented Best of Show awards to products in three categories—database design, database management, and database applications—at the spring SQL Connections conference in New Orleans. ER/Studio from Embarcadero Technologies won the Best of Show award in the database design categor

Without coding custom reports or complex forms, you can now enable users to search and run reports on information in your database-driven Web site or application. Microsoft discovered a way to use a flexible search-specification mechanism that comes with a remarkably easy interface: the English lang

If you're a diehard Microsoft BackOffice Server (BOS) aficionado, you might have noticed that we announced the launch of the new BackOffice Server UPDATE newsletter at the same time Microsoft announced the BOS 2000 beta release. That wasn't a coincidence: the primary focus of this newsletter

This article describes the Index Tuning Wizard in Microsoft SQL Server 2000. The Index Tuning Wizard simplifies the task of identifying which indexes to create in a table and also optionally generates scripts to create them by analyzing a user-supplied workload. Various modes are offered for tuning

In revamping the way SQL Server implements security in the 7.0 release, Microsoft created a flexible and powerful method for managing users’ access both to the SQL Server system and to the databases. The changes also created confusion as administrators tried to upgrade from SQL Server 6.5 security.

Another solution we have found is to use the offerings from Microsoft's SQL Server 7. SQL 7 has a few key pieces of functionality that lend themselves to the sometimes disconnected user. The first key piece is the MSDE (Microsoft Data Engine), which is actually the guts of SQL 7 without the fron

Enterprises need the ability to quickly analyze and access diverse information sources in order to make better decisions. To meet this challenge, it is necessary to integrate, consolidate, and summarize information from heterogeneous data sources. By doing this, you create a data warehouse—a large,

On October 6, 2000, Compaq published a new record-setting TPC-C result, recording the highest performance ever, running Windows 2000 and SQL Server 2000. With a performance rating of 505,302 transactions per minute (tpmC) and price/performance of $20.68 per tpmC, the 24-node ProLiant system is the f

Get an overview of the newest SQL Server 2000 features.