Updates, deletes, inserts, index rebuilds/reorganizations. Those are just the few things that come to my mind that is going to be logged.

Stylez (8/17/2012)

---

Hi Lynn. Yes, I was trying to Set All The Dates To January 1 (For Data Scrubbing Purposes). i am also thinking if a trigger is causing this error?...

Charmer (8/17/2012)

---

Lynn, what about trailing spaces.....? they are char data type .....so if data is less than the exact length, automatically the reamining length will occupied with empty spaces right?...

Looks to me like you have a very active database even for its small size. I can understand the initial tlog being large, as it is all the activity...

Stylez (8/17/2012)

---

Good Morning Guys,

i wanted to ask you guys on your 2 cents on this. i was trying to run an Update Query with a Subquery and did not allow...

Charmer (8/17/2012)

---

Lynn Pettis (8/17/2012)

---

Charmer (8/17/2012)

---

Lynn Pettis (8/17/2012)

---

If you mean that your query is loading a staging table, that isn't what I am talking about. I am talking about copying...

jralston88 (8/17/2012)

---

My understanding with these tasks, if the fragmentation is greater than 10% and less than 40%, reorg. If it is greater than 40%, rebuild.

I'd like to set some...

Couple of things.

One, when...

Two questions.

First, why are you copying the records with a different sequence no (really just curious about the business requirement)

Second, why does it have to be done in SSIS? ...

Charmer (8/17/2012)

---

Lynn Pettis (8/17/2012)

---

If you mean that your query is loading a staging table, that isn't what I am talking about. I am talking about copying the data from...

What?? Does NOONE have a working crystal ball?? :w00t:

Reraise the error CATCH block. About the only way I can think of handling it.

If you mean that your query is loading a staging table, that isn't what I am talking about. I am talking about copying the data from the source tables...

It was a thinking question. I never even counted how many ways a variable could be set to a value. Having to leave out the basic SET (I...

If you can't clean the data in the source tables prior to using it, stage the data in temporary tables, cleaning the data as you load it. After loading...