I created a unique constraint on a column called Col1 in table Test1 to enforce uniqueness with the exception of NULL. The entry for "Unique Constraint" in SQL Server Books Online (BOL) specifically says that you can create a unique constraint on...
Editor's Note: SQL Server Magazine welcomes feedback about the magazine. Send your comments to letters@sqlmag.com. Please include your full name, email address, and daytime phone number with your letter. We edit all letters and replies for style...
The only measures useful in some types of analysis are measures that are derived from multiple loaded measures (i.e., those from the fact table) or from some calculation that uses other dimensions. In such cases, you need to create a cube that has...