Thank you for your article Jacob. It is very useful. I read your other articles and I am impressed by your ability to explain things concisely and clearly.

Kind regards,

Vincent

Thank you for posting this useful article, Mike. I also had the same experience in the past with the same cause (sp_recompile).

Regards, Vincent

Thanks you for sharing your experience Leo. It's a good and useful article. We use a data warehouse where the data from stage is loaded alternately into 2 sets of identical...

Thank you for posting this article, Haidong Ji. The "ed" thing is also there in Oracle sqlplus.

Boris. I typed exactly as Haidong suggested and it worked: set sqlcmdeditor = notepad...

Hi Norm Johnson, if you send your email address to irainardi@yahoo.co.uk I'll send you some samples of DTS packages that I used to extract from source systems to stage in...

Hi Janet, thank you for writing your experience using DTS to load the data into your stage tables and into your dimension tables. I had similar experience, using DTS to...

Thank you for writing this article, Harsh. It's a good article. I learned about the version number from your article; I've used effective and expiry date and current version column...

Thanks David. Sometimes I wonder about that, why there are only 3 types of SCD, why don't we make a new type. Why only Kimball and Inmon method (and Barry...

Yes that is correct, Abeljda. We converted it that way because of the same reason: because we wanted to be up and running asap in 2005 with minimal effort and time...

Hi everybody, apologise I came late to the discussion.

Calvin, I'm not sure why the link is missing but the article is at http://www.sqlservercentral.com/columnists/vRainardi/2732.asp.

Steve, the link to the article...

Hi Stefan, you are right that in SSIS we can do all transformations and lookups in memory and write directly into the fact table. The reason we dumped the source...

Hi James, the link to the excellent SQL 2005 partitioning by Kimberly Tripp is http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sql2k5partition.asp, where as the one on SQL 2000 by Joy Mundy is

Thanks for the article, Jamie.

It was very useful.

Vincent

Thank you very much for your effort in interviewing Paul Randal, Steve. It's been very useful to know the people behind SQL Server, especially the storage engine. It makes SQL...

Thanks for the correction, Djoni. You are right Ascential is now WebSphere.

And thanks for the critics, Bill Edwards, I will try to improve it on my next articles.

Kind regards,

Vincent