Thanks Jeff.

I'm confused.

You're saying it's a good idea to have staging tables in a separate database

but then what do I do with Foreign Keys?

Flow is the following:

1. load into one...

He's a junior DBA..company is looking for Senior DBA now..

In the meantime they asked me if I can find any bottlenecks in

database performance and the causes.

I talked to DBA.

He...

24 Partitions mystery is clear now.

I talked to DBA.

They are planning to partition {Pink} table

and created these partitions as placeholders.

They partitioned {Poink_parttioned} tables will be moving data to {Poink} soon.

Thanks Allan.B

Ignore File Growth part.

Apparently they were doing something crazy on that day (October 3).

Preparing for partitioning Poink table.

Since October 3 there is only 1 Log File Grow per...

Sorry.

PING is ok.

I wasn't using full name correctly.

Ping works fine:

ping BNDARGSQLP51.bbl-sg.local

Pinging BNDARGSQLP51.bbl-sg.local [10.146.173.51] with 32 bytes of data:

Reply from 10.146.173.51: bytes=32 time=1ms TTL=126

Reply from 10.146.173.51: bytes=32 time=2ms TTL=126

Reply from 10.146.173.51: bytes=32 time=2ms TTL=126

Reply from 10.146.173.51: bytes=32 time=2ms...

But keep in mind.....

When I connect using SQL Authentication

it is fast.

So probably it's not DNS issue.

Could it be connection to ActiveDirectory issue?

When I run

select * from sys.dm_exec_connections

In auth_scheme

I see:

SQL - majority of records

NTLM ...

Where do I need to run

ipconfig /all

?

On SQL Server physical box?

I don't have physical access to the box.

------------------------------------------------------------

------------- More details: ------------------------------

------------------------------------------------------------

i am on BLL domain.

SQL Server is on...

Thanks Jo.

I guess the TRUST is there.

Because we use Windows Authentication to access SQL Servers on the other domain.

Users in BLL domain.

SQL Server in BLL-SG domain.

But this kind of setup -...

In PAT (pre-PROD) environment.

performance is terrible.

77 rows returned in 2 min and 56 sec..

Very slow...

Execution Plan is attached...

Just to let you know guys..

Calls to function that splits strings costs nothing (0%) in Execution Plan..

So I didn't bother to pay attention to it...

Phil Parkin !!

Your recommendation was the most valuable !!

Thanks a lot.

I added clustered unique index on table variable @lists.

declare @lists table

(

value varchar(50),

paramname varchar(20),

UNIQUE CLUSTERED (value, paramname)

)

Unfortunately with regular temp table...

I found the problem.

At the top of

FATCA_TDS_MASKED.SP_GENERATE_XML_CONTENT_MASKED

there was a call to log procedure - EXECUTE [FATCA_STG].[SP_ETL_LOG]...

It was inserting a record in LOG table.

As soon as I remove it,

SSIS package recognizes...