sperry (5/16/2009)

---

...

I had to make a small change to add source-name into the functions so now it looks like this

WITH cteSurname95 as (

Select Source_Name,Name_Variation

From...

Oops, thought of something else...

sperry (5/16/2009)

---

Thats for that. have run it and it does not seem to have helped. Without searching for name variations the query takes 17 seconds. I...

sperry (5/16/2009)

---

Thats for that. have run it and it does not seem to have helped. Without searching for name variations the query takes 17 seconds. I have let it run...

Shawn Therrien (5/15/2009)

---

Okay, those are a lot of good reasons. Now most of them seem to imply that stage is on another instance of SQL server, preferrably on another machine....

Right, the problem is that in reference to your original question "why an SSIS package would run slower on the server than it does in BIDS on my laptop?" there's...

Shawn Therrien (5/15/2009)

---

We've been importing tons of data into a staging database through TSQL Scripts, performing transformations on the data and then importing into our test/live database depending.

I'm looking...

You're actually asking two different questions here Shawn:

1) Whats the best method for Updating/Maintaining DW tables?

and

2) Why do I need a staging Database?

Since (2) is simpler, I will answer that...

tvanharp (5/15/2009)

---

Can anyone tell me why an SSIS package would run slower on the server than it does in BIDS on my laptop?

I'm guessing it has something to do with...

Oops! I forgot to ask. Dang, I would have fallen hard on that one!

Florian Reischl (5/15/2009)

---

RBarryYoung (5/15/2009)

---

It doesn't seem to be doing that on my system:

--========

declare @s-2 varchar(30)

declare @t varchar(30)

set @s-2 =...

It doesn't seem to be doing that on my system:

--========

declare @s-2 varchar(30)

declare @t varchar(30)

set @s-2 = 'K ...

Actually, even more that that, I need the listing of the "spDBSys_GetTableRowKey_sproc" stored procedure.

Can you provide the CREATE TABLE DDLs for the referenced tables also?

thnx

OK, try this and see if it is any better:

;WITH cteSurname95 as (

Select Name_Variation

From Names_Database..Surname

Where Score >= 95

), cteForeName95 as (

Select Name_Variation

From Names_Database..Forename

Where Score >= 95

)

SELECT...

Could you post the DDL (including keys & indexes) for the Surname and Forename tables?

thnx,