I want to insert data in append mode to tune my trigger.
The package deletes from tableA, a trigger inserts the deleted data row by row into history table.
It is taking 2-3 hours to insert into tableA_hist history table.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…