A message from our CEO about the future of Stack Overflow and Stack Exchange. Read now.

Questions tagged [incremental-load]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
1answer
2k views

SQL Fastest Way to find Data Difference Between Two Tables

I am trying to locate fastest way to find difference between two tables. The first table is populated from text files daily, the second table is maintained in our database. We need to add data that ...
0
votes
1answer
24 views

Counting entries of a unique entry of another field and concatenate the result with the unique field in a new column [closed]

I want to create a query that will search the table and find the following: If a POL_N entry has ENDO_N entries then the COUNT ENDO_N field will start counting the ENDO_N entries and will get the ...
1
vote
2answers
62 views

How do I run a stored procedure only on newest data loaded?

My database has a table where the data is loaded from an Excel upload. Then, a stored procedure is run on the data to validate it and insert it to another table. Currently, my stored procedure will ...
2
votes
1answer
481 views

Incremental Database/Data Change Restore

I have vendor production backup that needs to be restored onsite daily. The most frustrating part is that their installation is on SQL 2008 but the DB mode is SQL 2000. sigh!!! The database in our ...
2
votes
3answers
2k views

ETL: extraction strategy for 200 source databases

What is the best extraction strategy for approximately 200 SQL Server 2005 source databases (same schema) for a daily load into a staging area in preparation for data warehouse cleansing, de-...