A parent-child dimension is based on two dimension table columns that together define the lineage relationships among the members of the dimension. One column, called the member key column, identifies each member; the other column, called the parent key column, identifies the parent of each member.

(Steve Schofield) One of the items I like to do from time to time is have a fresh copy of a production database on a local SQL Server. The local copy usually would be used for performance testing, application development etc. Microsoft SQL Server 2000 uses DTS (Data Transformation Services) to help

(Jaya Nehru) Before you start testing any database-driven application, the first thing you need to do is: –Remove the old data from all the tables. –Reset the identity back to 1 for every one of the tables.

(Greg Robidoux) SQL Server 2000 offers three recovery models for each database: Full Recovery, Simple Recovery and Bulk-Logged Recovery. The recovery models determine how much data loss is acceptable in case of a failure and what types of backup and restore functions are allowed. (R)

(Arun M.Patil) In my first article I have explained how to create new database along with database files. This second article is useful for beginner’s who are learning SQL Server 2000 database. Now you learn how to create table in database. Before creating the table you need to understand table

(Mat Stephen) Following Deepak’s question, asked in his comment on my previous UDM post, I quizzed our internal Yukon alias and received the following useful info regarding using SQL against a UDM; thanks to Akshai Mirchandani.

(Rudy Limeback) I want a query for retrieving the top two recently inserted records for each id. My table has columns id, adate, and description. There are five records with id 2 and four records with id 3. I want to retrieve top two records for both id 2 and 3. I should get total four records,

(Scott) Microsoft introduced table variables with SQL Server 2000 as an alternative to using temporary tables. In many cases a table variable can outperform a solution using a temporary table, although we will need to review the strengths and weaknesses of each in this article.

(William Pearson) In working with many reporting tools over my career, particularly within enterprise business intelligence suites and high-end production reporting systems, I have become acquainted with various control features in each that allow administrators to govern the actions of end users.

(Rushi Desai) Anyone who has written a web application has probably experienced the cost of doing a database round trip for fetching a result set everytime a web user loads a page. In fact, handling a page request may involve more than one queries (imagine 20 drop-down boxes, each of which must be p