Excellent stuff and very detailed. Thanks for sharing. I have done something similar in the past but never thought of using triggers, instead compared the data between old and new...

Nice script! As an alternate workaround you could also make use of bcp command.

Thanks

I don't know if this is feasible in your environment but thought it was worth mentioning.

Instead of copying large backup across network, can you instead backup the source database to...

Did not get it right :(, got tricked by the extra comma after the last column. Had it not been for the extra comma i would have answered it right....

If your concern is table getting locked during duration of the SSIS Insert, apply the inserts in small number of batches and commit often, this will avoid lock escalation on...

Did you try looking at the SQL Server logs? Try command xp_readerrorlog to see what it is doing.

Thanks,

Ninja's_RGR'us (3/1/2011)

---

SKYBVI (3/1/2011)

---

ChazMan (3/1/2011)

---

I'm still confused about how the page is full. Since data pages are 8K and we are only using 4K, how is that full?

Also, in my...

1000

Thanks

Another thing that comes to my mind, is

1) Use TABLOCK option on OLEDB Destination adapter, this causes the inserts to speed up.

2) Unless absolutely necessary, replace the row by...

sarah.morgan 91551 (1/28/2011)

---

I work for Firebrand Training, Microsoft Gold Partner in learning IT solutions, providing professional MCITP classroom based training. The following should ideally give you a good preparatory information...

aaron-403220 (1/25/2011)

---

I ask because posting personal information on a public website would go against anything that a DBA learns.

Even if it is data from India, this should have raised a...

Well, those are real Indian names probably you may have never heard before. Dunno...

Again it depends on the Job location and experience and ofcourse the company that is hiring you! Big 5 companies in metros may be able to pay that compensation but...

Create copy of the table that is identically same with the correct structure. Copy data from the existing table to this new table. Switch the table names.

After that you might...

Hi all,

I have been working on SSIS for about 4 years now. But i have no working experience in SSRS/SSAS/Cube design.

Can i still take the exam MCTS 7-448 without prior...