Mister Magoo,

Thanks for shedding some light on AddEvent. To be honest, I prefer my Oz mysterious and behind the curtain; I don't want to know how big of a sham...

I'm sorry I misunderstood the difference between a subscription and a subscription "event." I wish understood better what an "event" is with regard to SSRS subscriptions. I'm having trouble finding...

This is a very interesting article. I once tried to do something like this with an earlier version of SQL Server with the web service API and .NET but was...

CELKO,

Thanks for taking the time to read the article and to respond.

This is quite true....

Jonathan AC Roberts,

You can't create an indexed view from a self-join query.

When I try to create a view with the query you provided I get the following message:

Msg 4512,...

Steve in Fairfax,

I think your code snippit is the most accesible and understandable of the solutions offered in the posts. Of course, some would argue against relying on functions which...

Jonathan AC Roberts,

Bad news - I've been unable to create an indexed view for your query. First I had a few problems creating a view with schema binding - SQL...

Athos,

Yes, I do find ((2*isActive)-1) a bit scary, even though I do understand what it does. In general, complicated arithmetic in a computed column gives me the willies.

-Dan

Jason Hannas,

Your code does indeed solve the problem by only adding a computed column and a foreign key. I'm not sure how well it would work with other constraint problems,...

RonKyle,

To be clear, my post about using triggers vs. an indexed view for a specific problem referred to Jonathan AC Roberts's example:

You could use it to catch the problem where...

(deleted).

Jonathan AC Roberts,

I'd be curious to see how your problem would be tackled by Trigger Champions (imagine chivalrous armored knights jousting for the sake of the favored programming construct). My...

athosfolk,

Your technique is very interesting. As I understand it, your technique eliminates a semi-bogus table and an indexed view with a computed column and a check constraint. The calculations scare...

RonKyle,

I can't really dispute your points regarding the benefits of triggers. One argument that could be made in favor of the technique I described is that it doesn't require transact-sql...

Alex Fekken,

I like your performance suggestions. I envision using the indexed view technique on small reference tables where performance might not be as important. I think on large, frequently used...