Bill Tidwell (6/6/2011)

---

Craig,

Thanks so much. I might be a couple of days before I can focus on this, since the week has reset back to Monday.

I scanned through it...

Alright, finally got a little time to go delving into this.

This end is end to end test code, and worked in 2k5 Express, so nothing funny's going on, though I...

Lynn Pettis (6/4/2011)

---

Okay denizens of The Thread, I got a call yesterday evening from my oldest daughter that actually left me speechless.

I am going to be grandfather![/i]

Looks like I'll need...

I've always thought of most certifications as the rest of the world thinks about college degrees. Just because you shoved knowledge into your head for a few years, doesn't...

Ishrar, a few things.

1) Congratulations on your first post being both coherent and explanatory. My hat is off to you for remembering to bring your brain to the discussion....

If the spid isn't blocked, it's in the tempdb spooling. Look for contention on the raid for the tempdb.

I realize that's kind of a leap, but it's the only...

Jeff Moden (6/3/2011)

---

You'll have to trust me for a bit... I'm not going to post the code or the other charts here because this problem of people using Recursive CTE's...

Vedran Kesegic (6/3/2011)

---

So, there really are kind of full, differential, and incremental backup concepts in sql server.

Backup software, like backup4all (google that, or use direct link: http://www.backup4all.com/en/help/backup_types.html), have really well...

Thanks Bill, that helps tremendously.

Now, I'm going to need your help understanding the components of the stream.

First, I need to know where a record starts. Is it on the...

I'd start with figuring out what in the proc(s) needed to be tuned. Tuned for speed, tuned for concurrency, or tuned for reducing I/O.

Usually, I tune for speed.

From there,...

If you haven't already, double check that your connections in the SSIS package, and your configurations, are pointing where you think they are. May just be a typo.

Next step...

This is a common problem when working with older mainframes. As OPC pointed out above, being able to consume the data easily in a test structure will assist us.

In...

Can't, a group can't own a job or package. It's been driving me nuts for developers for years when I don't want to give them overkill rights.

mister.magoo (6/2/2011)

---

For anyone who thinks that an infinitely recurring number can simply be redefined as another number, I ask this question:

Does PI (3.14159 etc ) which never repeats = 3.141.......

Glad...