monilps (1/13/2016)

---

Hey Phil,

The query is close by what I am looking for but two things:

- Query is only resulting back original rows which has similar duplicate data.

- What if data...

This fits your example data. But is it too specific for your real-world data?

if OBJECT_ID('tempdb..#dupes') is not null

drop table #dupes;

create table #dupes ( Id int identity (1,1) primary...

I'm sorry, but your vague single-sentence responses are not providing the level of clarity required to answer such a complex...

OK, this answer contradicts the earlier one.

So ... you want to identify rows where another row exists which is 'similar'.

'Similar' here means that all...

monilps (1/13/2016)

---

Hi,

I need to identify possible duplicate (not exactly duplicate row) data without primary key:

Table A:

Col1 ...

Please explain how the 'customized' figures are determined.

Letron Brantley (1/12/2016)

---

Phil Parkin (1/12/2016)

---

I just read through the link you suggested. It suggests that the parallel loading of a table will work if that table is a heap. Otherwise...

JustMarie (1/12/2016)

---

Letron Brantley (1/12/2016)

---

JustMarie (1/11/2016)

---

To address the situation of gap fill or other re-run situations I use a parameter table.

One package to populate the parameters.

One package to pick up the...

Letron Brantley (1/12/2016)

---

I have a question regarding the Microsoft Balanced Data Distributor.

http://blogs.msdn.com/b/sqlperf/archive/2011/05/25/the-balanced-data-distributor-for-ssis.aspx

Does anyone have any insight into how SQL Server handles target table locking if you use the...

Please provide some sample data in easily consumable format, as described in the link in my signature.

declare @HearingDate datetime = '20011006'

Declare @HearingTime varchar(5) = '0830'

select @HearingDate + cast(stuff(@HearingTime,3,0,':') as datetime)

With over 1,000 posts, you should know by now that 'SSCommitted' is not Jacob's name 🙂

Why not use a native C# application? What benefits do you think that SSIS is giving you?

And if you are trying to choose between VS2012 and VS2013, I'd recommend VS 2013: it's newer and (IMO) better.

Eric M Russell (1/11/2016)

---

You probably already know this, and you didn't specifically mention SCD or if this is a MERGE versus straight INSERT into Destination, but avoid using the SSIS...