Matt Miller (#4) (10/26/2014)

---

Managers should and can be a HELP not a hindrance: mine routinely plays the role of "left tackle" to keep my way clear to get...

Doctor Who 2 (10/27/2014)

---

I read this article with great interest. I've not had the pleasure of being on a team that wanted to use either CI or CD. But I...

Um, thanks sqlVogel for that utterly useless link. Slightly funny, but utterly useless.

fizzleme (10/27/2014)

---

The documentation says put log files and tempdb on separate database partitions. We use raid...

CI works in the app development world because of a particular idea: non-persistance of the layer. I'm not discussing the concept of CI, but the reality of its implementation....

Just to confirm, you're rt-clicking the dtsx and opening it in, say, Notepad++, then moving down to the DTS:ConnectionManager with the "ObjectName" for your connection in the package, and looking...

There is a difference in the pra.ID = xx(x) line. Safe to assume that's a typo?

Offhand I don't see any reason you should be returning more rows. I'd have...

Mr. Celko, I have I a request.

Please either go away with extreme prejudice, or bring the personality that you (apparently, due to source I trust) have in real life to...

Short answer: Drop off the email and the name into an ADO Recordset object from a dataflow (feed your select statement into a recordset target).

Use that object variable as the...

Hyper-V in particular isn't something I've used, but other clone softwares are things I've witnessed. The are avoided like the plague simply because the database is basically trasferred in...

It comes down to the fact that you've built a large parameter list at the top, and you're expecting that to be the declaration for all local scopes. Think...

Oh, this should be interesting... *grabs popcorn*

Sic 'im, Scott!

Thanks for the link Nick. I'm...

Eddie Wuerch (10/8/2014)

---

1. Do not drop #tables when you are done with them - let them go out of scope at the end of the proc and allow...

Nope, because that depends entirely on where you work. Do you have BA's and PM's? Are you working against a warehouse that's built by a data architect, or...

Sincerely appreciate you being honest about this is for a class. You'd be surprised.

So, with that in mind, what you're running into is a topic called "Implicit Conversion". ...