Analysis Services is powerful and easy to use. I don't get why they can't put a good web bases viewer on top of it.

I do this with shared schedules.

I've got about six shared schedules which are triggered at various times in my etl process.

I have a stored procedure...

roger.plowman (12/24/2012)

---

I always liked the library analogy.

The clustered index is how the books are shelved (usually by Dewey Decimal number), the non-clustered indexes are the index cards in the card...

timothyawiseman (5/8/2008)

---

Comments posted to this topic are about the item

...edited from article...

Both sp_who and sp_who2 with its added columns can be tremendously valuable in scripts and programs, but...

I don't see the advantage of using PIVOT rather than the tried and true sum(Case when.... method. You still need to specify the columns in either case. ...