Posted. Overall, I am quite pleased with TVPs

Much the same as table variables, large datasets can become problematic.

However, it depends on what you are coming from. We switched to TVPs from string splitting and saw huge...

Do you need a script that will just display the memberships and security for that user.

Or do you need something that will generate the scripts to recreate that user with...

Oooh - that could be fun - must have experience.

Nice analogy

Ninja's_RGR'us (8/18/2011)

---

Sorry to break the rules but..

I've possibly discovered a bug that corrupts your db when doing a deployment script. I've tested on 2K5 sp3 and 2K8 R2 RTM,...

That is a definite perk.

I would add...

Well, I found what was causing my solution to run slower. It was relative to that dynamic numbers table but not how I expected.

By removing the selection against the...

Try this

http://www.sqlservercentral.com/search/?q=backup+all+databases&t=s

I can see more as to why it is puzzling.

Have you checked all the firewall and nic settings on the destination server?

Ha - I love it.

Cadavre (8/18/2011)

---

SQLRNNR (8/18/2011)

---

Cadavre (8/18/2011)

---

SQLRNNR (8/18/2011)

---

Well, that is about 12 times faster on my machine. Where did you pick up that trick?

I need to delve a bit more into it...

Woot - nice question.

Cadavre (8/18/2011)

---

Not really...

Alex Webber (8/18/2011)

---

True. What I just don't get is that it's gone from 1 hour when backing up to 1 machine over the network to 15 hours when backing up...