Jeff-  I agree.  I was too hasty in my initial thought process.  Change is inevitable.  Change of thought for better is not 🙂

Jeff-  This is not for legal reasons.  We have multiple sites (manufacturing) and we are trying to build an Enterprise platform to be able to do analytics across all the...

Thanks Michael.  The issue is I don't want to touch the existing vendor DB.  It is anyways out of support but it still works and we don't want to change...

Thanks Steve.  Let me explore the diff tools option.  Issue is that Fivetran (ETL tool) goes after SQL Server CT system tables to get the changes.  I am sure there...

May be this is a better example of the approach to add a Identity column to all the tables to make them the PKs.  Just thinking through.

INSERT INTO Table 1

SELECT...

Thanks very much for your time Grant.  The reason why I had Identity on the second table also is because, if I add a surrogate key column to all the...

• This reply was modified 2 years ago by  cbarus.

Or is this information already available in a system table and I am re-inventing?

Here is what I am trying to do and my query below.  I am trying to see how many rows changed per table in a day and I would insert...

Thank you both for the replies.  Ratbak, this is exactly the query I was looking for.

I greatly appreciate your time

Ed- The output is 1 and 1.

Ed Wagner (10/28/2016)

---

cbarus (10/28/2016)

---

I am working with a client who has six SQL 2008 R2 Standard instances. I am setting up SQL...

The other option (not as optimal using OUTPUT) is to generate these IDs yourselves. You could prepare the data sets and insert them into the main tables with INSERT...

My company has our own flavor of Agile. When we initially started brainstorming about adopting Agile last year, one thing we all agreed is that the first initial sprints...

My personal preference would be option 3, provided you have finite number of countries and they dont keep changing frequently.

One way to accomplish this would be soft coding. The key to either go this direction or not is the volume of the data. Let me know the...

One reason I could think of is the log size. I have had a similar situation where I had to move around 200 M rows from one table to...