Jeff Moden (9/5/2010)

---

Sooooo... now that we've taught someone how to accomplish SQL Injection, I have to ask... will he use it to avoid injection or carry out revenge on some...

Jeff Moden (9/5/2010)

---

Lynn Pettis (9/4/2010)

---

We are using 8g and 10g. From what has been discussed, one of the databases will be moving from 8g to 10g. This is...

SQL Injection is used by hackers in an attempt to steal or damage a company's data. It is usually a result of poor programming using dynamic sql constructs. Not...

I can say that I know they are using MS SQL Server locally, unless someone has learned how to run SharePoint with an Oracle backend.

We are using 8g and 10g. From what has been discussed, one of the databases will be moving from 8g to 10g. This is to eliminate duplicate data...

PaulB-TheOneAndOnly (9/4/2010)

---

Lynn Pettis (8/31/2010)

---

Found some resources, SQL Reference Guide for Oracle 10g. Guess what, Oracle actually has CTE's, they just don't call it that in the reference manual.

Having access...

Gianluca Sartori (9/3/2010)

---

Yesterday I had a wild argument with my boss, claiming that a column named "description" could be perfectly suitable for a foreign key.

I had to leave the office...

IIRC, it is actually a myth that Oracle runs better with loops and cursors. Perhaps I'll have the opportunity to verify that well written set-based queries run better than...

Alvin Ramard (9/2/2010)

---

Lynn Pettis (9/2/2010)

---

Looks like I've missed something on forums the past couple of days. I've been fighting a cold/allergies plus the new job, just haven't been on...

CirquedeSQLeil (9/2/2010)

---

Alvin Ramard (9/2/2010)

---

Jason, you can keep an eye on that 2005 upgrade if you want. I'm running for cover.

Would you let someone who's not sure how to install...

Alvin Ramard (9/2/2010)

---

CirquedeSQLeil (9/2/2010)

---

jcrawf02 (9/2/2010)

---

Tom.Thomson (9/2/2010)

---

Surely you don't expect all the posts to be...

Alvin, how about you

How about we simplify the whole thing:

select ceiling( Alvins-calculations )

That means 26 posts...

Not sure what your problem is, SQL Server will use as much memory as you allow. Besides using SQL Server 2008, are you running x86 or x64 version?

If you...

GSquared (9/1/2010)

---

Here's an interesting one. This is the list of skills someone wants for their "DBA":

Must have advanced proficiency and extensive knowledge of web development and design technologies, and...