Viewing 15 posts - 1 through 15 (of 32 total)
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...
December 2, 2014 at 6:42 am
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...
December 1, 2014 at 8:30 pm
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.
August 8, 2014 at 3:57 am
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...
August 7, 2014 at 10:32 pm
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...
October 17, 2013 at 4:17 am
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...
August 21, 2013 at 5:48 am
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...
August 21, 2013 at 3:07 am
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...
August 21, 2013 at 1:41 am
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. -
August 20, 2013 at 11:56 pm
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...
February 28, 2013 at 11:35 pm
Ok. got you.. Thanks !
February 12, 2013 at 2:25 am
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...
February 12, 2013 at 2:09 am
Clustered index on VersionID in dbo.VersionTable
December 20, 2012 at 1:15 pm
Some more information on that -
I get -
LCK_M_S on the following:
Waiting on statement:
SELECT TOP 1 1
FROM dbo.VersionTable ...
December 20, 2012 at 12:00 pm
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 <>...
December 20, 2012 at 10:35 am