Thanks!

By the way, what are the risks?

I recently had to fix a situation where half dozen of production tables got truncated. So I read your article with great interest.

However, after reading it, I realize we still...

Steve Jones - SSC Editor (1/15/2015)

---

Eric M Russell (1/15/2015)

---

My point is that the fundamental difference between relational databases versus Big Data NoSQL databases is actually not technical or even philosophical;...

Hi,

I like the script but...

I like it as it replaced my broken ps which was fine with sql2008R2 but failed on sql2012. Also it runs flawlessly when my servers sitting...

Good question!

I found some of these select N hints make these questions less valuable. "Select all the correct answers" is a better option.

Using n out m are the correct ones...

If you have less than 10 concurrent users, then this might work. Otherwise, the performance will always be an issue.

Particularly, the power Access useres will treat these linked tables as...

Have your programmer write a little utility that will save the excel as csv.

I've heard what you said about not to use CSV format, but I still want to argue, that probably is your best way to resolve this for good reasons.

Stripping data...

Lot of minor areas that I have wished that could be more polished and more ready for prime time.

For instance, in DTS you could double lick to select mytbl_imp...

Well, you "look up" them through your code or SSIS task. Something like this:

Update A

Set A.geo_FK = B.geo_PK

from fact_sales A Join dim_Geo B

on A.City = B.City and A.State = B.State

--and...

Pk on the dim table has changed to a new value. Its counter part in the fact FK needs to reset to that value. That is what I meant "remap".

You have to look into somehting along the line of web control/browser control that will be hosted in win form and render the SSRS contents for you.

On the other hand,...

Let's stick with Kimball mathod for a minute.

These PK/Fk pairs are surrogate keys not the natural keys from OLTP. They should be built during initial OLAP load and maintained in...

Well, you did not say why you want to rewrite them into SSIS. Typically, if these DTS packages are simple and you are not looking ways to improve them, the...