It's just another OODBMS (object oriented database management system) from what I can tell.

So, yes, it will be faster in some things, and much, much slower on others.

Usually, OODBMS engines...

RedGate can also use a GUI, not just command line.

I haven't used the other ones. I've used RedGate and ApexSQL (not on your list, but they have tools for...

I'm accustomed to SANs with multiple fiber channels, so can't speak to that aspect of it.

I've been using servers where both data and logs are on the SAN for years,...

Evil Kraig F (12/14/2011)

---

I must be crazy, I haven't lost track of the thread and I'm pretty sure I know the story Gus is talking about! I think I...

Let me guess, the problem was the implicit conversions being short-circuited. That'll add so much to the cost that the optimizer was bypassing it. Right?

ricardo_chicas (12/14/2011)

---

the checkpoint spid is blocking all the other sessions on that databse, I can do anything on that database, I know this is not isolated, internet is plagued with...

I'm not sure how a checkpoint "blocks everybody else". Can you clarify?

A checkpoint is simply SQL Server writing data out of RAM onto the hard drive (essentially). Are...

L' Eomot Inversé (12/14/2011)

---

GSquared (12/14/2011)

---

Well, per the French scholars Goscinny and Uderzo, it was actually the ancient Gauls who used this method of settling certain disputes. Usually disputes over...

It shouldn't be hard to do. I've built such systems (one pretty much managed a whole small business on its own, and did a better job of it than...

If the DBAs don't allow bulk insert or ad hoc queries, which is a common security measure, then SSIS is your best bet.

Koen Verbeeck (12/14/2011)

---

GSquared (12/14/2011)

---

Well, per the French scholars Goscinny and Uderzo, it was actually the ancient Gauls who used this method of settling certain disputes. Usually disputes over musical...

jcrawf02 (12/14/2011)

---

Ninja's_RGR'us (12/14/2011)

---

Pork chops is a projectile thrown in the face of someone who uses cursors, rbar and other forms of bad sql.

Kind of a more efficient and longer distance...

SQL Kiwi (12/14/2011)

---

GSquared (12/14/2011)

---

But do keep in mind that DataLength on Unicode strings can require math on the CharIndex result, or you'll get the wrong position. Len vs DataLength...

"Going"?

"Going"?

I'd have to drive a LONG distance in reverse to arrive at...

Yeah, but we're working on fixing that as fast as we can ....