Yelena: That's a typo from early documentation that hasn't been corrected everywhere.

Indexed views may be used in SQL 2000 Standard Edition by specifying the NOEXPAND index hint.  All editions allow...

Looks like you can dodge all the CASE statements With a NullIf(value, 2):

NullIf(Min(IsNull(CONVERT(smallint, PermissionField1), 2)), 2) AS NewPermissionField1,

Testing (in results,PermissionField1 should...

PIVOT works best when you are using aggregations (count(), sum() avg(), etc.).  In this case, because you want to return every value instead of the results of an aggregation over...

A really solid book is Ken England's Microsoft SQL Server 2000 Performance Optimization and Tuning Handbook.  It's less than 400 pages, and packed with info.  It's one of those rare...

This sounds like a homework question...

Have you tried it?  What was the result and what would you like explained?

-Eddie

56,000 bytes. (call it ~100kB, depending on your fill factor)

If this hypothetical table were real, then you've already spent more of your company's/customer's money thinking about this than the cost of...

The trick that's helped me the most: just book the test.

Once I start getting comfortable with what will be on the test - but long before I'm ready - I'll register for...

Jeff: CREATE and DROP prohibit use of the database name.  They must be executed in the context of the target database.

-Eddie

If you wish to cascade some of the time, based on the situation, then it sounds more like a business rule than a data integrity rule.  Business logic should be...

Be sure to fire a USE statement first, then the database context is set:

USE

MyDB

GO

SET

ANSI_NULLS,