Hi Grant - There are intent exclusive locks (LCK_M_IX)

As for the Identity Column CI - we will not be using this column in any query.

So what should be...

Thanks Grant.

The 42% cost is Clustered Index insert cost. There is one CI and 4 NCI on this table.

All the other costs are from Index Seeks.

Also, this PK that...

Thanks Koen this helps. So as I understand, if we encrypt the SSIS DB using TDE then all the packages deployed in SSDB will also be encrypted using TDE automatically.

thanks. SSIS does use standard Database encryption (and not TDE) for encrypting sensitive data ..my question is - if SSIS package is deployed on SQL server which already is TDE...

Master key is created at instance level and hence it is absolutely OK to create a master key for the destination database instance which you did.

The Certificate and Keys becaked...

Top Input : 30,200 rows

Bottom Input: 8,05,000 rows (left join input)

There is a HASH MATCH (left outer)

And when I comment out the LEFT JOIN (and its aligned columns), the...

Yes thanks for highlighting that. I did check the indexes on the table. There is a covering index in place already. I was getting an index scan on that covering...

Hi Chris.. am afraid will not be able to put the execution plan of the query here due to confidentiality issues.

However, the exec plan had all Index Seeks and one...

Thanks Kapil. It wont work because we need a join with the ID. NEed to check TimeId against each Person ID.

Got the query. IT was simple. -

select PDD.*

...

In the test environment, INSERT INTO takes more time as compared to SELECT INTO.

There are 20 million records getting inserted. In future there could be more. So I am...

Ok. got you.. Thanks !

Thanks yes I agree..

I am trying to design a table partition.

I have identified the Partition Key (Date) and for creating the partition function - the range.

I am trying to...

Clustered index on VersionID in dbo.VersionTable

Some more information on that -

I get -

LCK_M_S on the following:

Waiting on statement:

IF

(

SELECT TOP 1 1

FROM dbo.VersionTable ...

Thank you for your inputs. Would need one more direction here on tuning. All indexes are in place.

This is the only piece of code -

WHILE @VersionID <>...