January 2002 MDX Puzzle Solution Revealed

Jan 23, 2002

table.downloadBox { width: 100%; border: solid 1px #666; border-collapse: collapse; } table.downloadBox th { background: #276C9F; padding: 3px; color: #fff; font-size: 14px; text-align: center; } ...

Surrogate Key vs. Natural Key

Jan 23, 2002

Does your candidate for primary key pass the four tests?

Grouping Time Intervals

Jan 23, 2002

Try this set-based trick to solve a common problem

Set Sail with Visual Studio .NET

Jan 23, 2002

Look beneath the surface at some developing changes...

February 2002 MDX Puzzle

Jan 23, 2002

A good analysis solution provides up-to-date, relevant information. For some businesses, the most important information predicts end-of-quarter sales figures. Using the FoodMart 2000 Sales cube, create a calculated measure that returns a...

Firing a Trigger for Each Inserted Row

Jan 23, 2002

I'm using an INSERT INTO...SELECT * FROM bulk statement to insert records into a table. If I write a trigger on the target table that executes on INSERT, will the trigger fire for each row inserted? If not, how can I get the trigger to fire for...

Converting from XSL to XSLT and the context() Operator

Jan 23, 2002

table.downloadBox { width: 100%; border: solid 1px #666; border-collapse: collapse; } table.downloadBox th { background: #276C9F; padding: 3px; color: #fff; font-size: 14px; text-align: center; } ...

Changing a Column from NOT NULL to NULL in T-SQL

Jan 23, 2002

I'm using Enterprise Manager to alter the structure of a table that has 3 million rows. Enterprise Manager locks up whenever I try to change the nullability of one column from NOT NULL to NULL. Is this problem a known bug...

Visual Studio .NET Database Features

Jan 23, 2002

Visual Studio .NET, the latest evolutionary step of Microsoft's premier application-development platform, includes more database-integration tools than earlier versions of Visual Studio (VS). Many of the new tools are direct descendants of the...