I've fixed this issue by setting Protection level to DontSaveSensitive on ALL Packages

Then re-deploying

Hi

Thanks for the replies

Basically, MDF, LDF and TempDB are all on the same disk, on the same drive (E)

I am aware this is not optimal and I am going to...

Thanks for the response Gianluca

In this instance, I need to know the code that causes the issue

Is there a way of establishing the impact of each component part of code...

Perfect!

GO was the issue

Thanks

Damian.

Thanks, a clustered index worked a little quicker although not as fast as I would expect

I do have a number of tables that are much larger and structured in a...

Hi

Just realised there are no indexes on this table so this is what I have:

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[E_DIM_POLICY_HOLDER](

[POLICY_HOLDER_BKEY] [varchar](255) NULL,

[POLICY_HOLDER_NAME] [varchar](255) NULL,

[POLICY_HOLDER_SHORTNAME] [char](255) NULL,

[POLICY_HOLDER_TYPE] [varchar](255)...

Separate issue - how do I edit the issue title?

Ah, looks like POLICY_TRANSACTION_BKEY wasn't unique

This table now has an identity surrogate key on it

Using that worked perfectly

Thanks

ok, so I am very nearly there using this:

SELECT TOP (0) IDENTITY(int,1 ,1) as ID, POLICY_TRANSACTION_BKEY

INTO #TEMP

FROM [F_POLICY_TRANSACTION]

-- Create a clustered index for efficiency

CREATE CLUSTERED INDEX TEMP__CL ON #TEMP (...

Thanks

That's runs through a lot quicker - less than a minute!

Interested to know why though

Why would the introduction of a temp table (with a join) for comparison run though faster...

Thanks Martin, I will give this a go

Damian.

So, in this instance, create 2 versions of the product Dim (say DimProduct and DimProductHistory)

DimProduct would really be SCD1 and be referenced by my Fact

DimProductHistory would be SCD2 and used...

Thanks for the response

Profiler doesn't quite give the answer

sys.dm_exec_requests for the session_id is useful

If I look at the start and end offset (then divide by 2 to get characters), it's...

Thanks Wayne

Exactly what I needed

Thanks

I've used the post deployment source and destination method

That works well

Thanks

Damian.