We used Lumigents AuditDB (Entegra at the time) in the past to capture log information in a db then replicate the information to another database. ...

Very good, to-the-point article.  I'm working on a DW project now and it's good to be reminded of some of the issues we will be...

Good and thorough walk-through of the product.  I checked Lumigents site and they claim Log Explorer does support SQL Server 2K5 so there is competition....

Did applying SP4 work?  If not check to see if you have a software based firewall turned on.

If you look past the insults back and forth, this could have been a really good discussion.  I thank Cimode for offering his ideas but...

Although I agree with Rudy in the sense that you should not generally create an index for a single query; A covered index does not need to satisfy multiple queries...

I re-read the question and no where does is say that the columns listed is all the columns plus there could already be a clustered index.  But no matter, the...

I agree with Mike C on this, if possible just create a clustered index on ProductID; otherwise you are basically duplicating the entire table in the nonclustered index.

As for having...

I agree with James... I looked at product about a year ago and although it appeared to be a really good tool, the price we were quoted was extremely high.  ...

I think this was a good and thorough article on SCD's.

One thing of note if you get the highest key value and manually set surrogates versus using identity columns then you...

I receive the newsletter daily usually late evening the night before.  There are times, though, that days are skipped... just so happens that I did not receive the newsletter today.  I...

Thanks for sharing your research on this.  Just wanted to point out one mistype... In your summary and graph you list test 2(OSQL - From Query Analyzer) at 32.6 seconds...

Very good article.  Too the point and easy to read.

A note to point out that although it's true that ROLAP is the slowest query performance of the different storage models,...

While I will agree that PDF would be a better option and should be considered a correct answer, there are a lot more readers of TIFF then PDF.  Any picture viewer/editer...

Good article.  Unfortunately we are stuck with a vendor that thinks XML is the best and only solution to data transfers, yet they have not...