I think you are correct, if you have direct access...

You have some good points Nadrek, thanks for bringing them up!

I have to say that I really appreciate the high-quality questions, and the follow-up responses that Paul provides. I have learned a lot from what he has provided.

And the small...

Brett Flippin (6/8/2010)If you were able to have your source system calculate the hashes for each record in advance you could get by very easily by not having to do...

Great article thanks! I can see where it might be able to speed things up, but only if you are constrained on your writes. In my current ETL process I...

Nice question, at least in it's current form.

Great question, thanks!

Great question, thanks Paul!

I'm really surprised at the number of people that think the log backups would be smaller. The logs files themselves yes, which is really the only reason...

Great question, I had to think about it, thanks!

Though I would have to say I would have made one of the choices "One row displaying the value 1", as that...

bitbucket-25253 (6/4/2010)

---

marklegosz

I liked the SQL as a graphic - stopped me from either running the code or adjusting the layout to read better. I actually feel better about having gotten...

I didn't even notice that, I looked at what the code was trying to accomplish and calculated the difference for each, I saw 15 minutes between so I put that...

Thanks for the question, I learned something.

I have to say putting the T-SQL as a graphic made it hard to answer because I couldn't clearly make out all the numbers...

Hugo, yes, my comment is in reference to the naming choices not the use of quotes.

I understand why people might like to use quotes instead of []s, but I...

Nice question, thanks!

Again, I probably wouldn't hire anyone who admitted to doing this. 🙂

malleswarareddy_m (6/1/2010)

---

UMG Developer (6/1/2010)

---

Wow, I happened to be the first to answer it, and I got it right. 🙂

Though not for the reason you stated, as it makes no difference...