The question is simply "are they faster", not "are they better", so I went with just that in mind when I answered.

I'm looking at it from "all else being equal",...

Can you copy msdb from one to the other? It's a bit tricky, and you'll want to look into other effects from it than just copying jobs, but you...

You can do your original idea. It's a really bad idea, but it can be done. My first database worked that way, and it was a mess in...

Eric M Russell (10/27/2011)

---

On the laptop I use to VPN into the office, I have separate boot and data partitions for personal use and then work, where one is not...

The Windows license limits are the main problem, as already mentioned.

However, setting up a VM with *nix (I prefer FreeBSD for this), and using that for browsing unverified sites and...

Kiara (10/27/2011)

---

Stefan Krzywicki (10/26/2011)

---

What dont you like about it? Everyone I know...

jcrawf02 (10/26/2011)

---

what do you guys use for calendar apps? (non-iPhoney people) <--hey, that's funny, didn't even mean that...

missed a couple user group meetings I meant to get to (online), would...

For nested XML, it's usual to use the Type operator at all levels. Otherwise, the subquery ends up as a string value, and it can do weird things if...

Ninja's_RGR'us (10/26/2011)

---

How come?? Never bothered to learn it...

benlatham (10/26/2011)

---

Still I would need a connection manager with which to query the database state and if that server is down the connection manager will throw an error which will...

kstjacques (10/26/2011)

---

GSquared (10/26/2011)

---

kstjacques: Most likely, if it's doing that, it's breaking your log chain anyway, and your log backups aren't doing you any good.

Have you tested point-in-time recovery with your...

george sibbald (10/26/2011)

---

Gus, no problem, it was just how your final sentence

'In summary, turn off log truncation. You don't need it, don't want it, and it can (will) break your...

GilaMonster (10/26/2011)

---

GSquared (10/26/2011)

---

Actually, it takes work to truncate a log file without running a backup on it, like setting the database to Simple Recovery, running DBCC ShrinkFile, and then setting...

George: What you don't want is to just truncate the log file without a backup. If you do a backup, you don't need to truncate it, because the backup...

Lookup table will definitely be faster and more efficient.