GilaMonster (4/13/2015)

---

Alan.B (4/10/2015)

---

Ok, quick update... I did some research on this - it appears that sys.partitions does not guarantee an accurate row count. According to Microsoft, the rows column in...

GilaMonster (4/13/2015)

---

Sean Lange (4/10/2015)

---

sql-lover (4/10/2015)

---

Is this an accurate way to get row count?

SELECT

t.name table_name,

s.name schema_name,

p.rows AS total_rows

FROM sys.tables t

join sys.schemas s on (t.schema_id = s.schema_id)

join sys.partitions p on (t.object_id =...

sunitkrishna (4/13/2015)

---

Sean,

Thanks for the answer.

This will work only when the designations are known beforehand,right?

In my case the designations are not fixed and we take the values from the designation table.

Any...

Yes. If you want 100%...

You don't want to get the "last row" modified as you stated. You want to get ALL rows currently being modified. Remember that triggers in...

sql-lover (4/10/2015)

---

Is this an accurate way to get row count?

SELECT

t.name table_name,

s.name schema_name,

p.rows AS total_rows

FROM sys.tables t

join sys.schemas s on (t.schema_id = s.schema_id)

join sys.partitions p on (t.object_id = p.object_id)

WHERE p.index_id in...

yb751 (4/10/2015)

---

Sean Lange (4/10/2015)

---

Slightly off topic here but I have to ask. When you say In/Out what does True represent?

This is wrong on a couple of levels. The first...

Slightly off topic here but I have to ask. When you say In/Out what does True represent?

This is wrong on a couple of levels. The first is that the...

Brandie Tarvin (4/10/2015)

---

Not that I've ever been that high, but I'm putting...

tomsharp85 (4/10/2015)

---

Hi Steve, I am not sure what you mean "What are you going to do when you want to have a SicText5? Or a 4th PreviousName?" How could I...

J0shu@ (4/10/2015)

---

Thank you so much Sean, this is very helpful. I also tested the implementation of CDC which the process looks to work quite well across all modifications to the...

J0shu@ (4/10/2015)

---

Thank you so much Sean for the great example.

A quick question \ concern (probably due to my lack of knowledge)

If I opt for essentially going horizontal vs....

maurer.martina (4/10/2015)

---

I see, there is no short way...

30 years ago I write a cobol-parser in 6 weeks in programming langage "turbo pascal". But cobol was/is an easy language, and I...

J0shu@ (4/9/2015)

---

Ok got it. I elected for EAV for ease to identify what attributes are getting updated and consolidating into a single column vs. having to scan across the table...

Thanks for the updated plan. Now can you post all the other information needed to help? The article I reference...