Steve Jones - SSC Editor (12/2/2015)

---

then I add a line.

select col

from table

where name = x;

and color = 'red'

And I get a syntax error and my eyes...

Nice link. Thanks, Robert.

Heehee.

Luis Cazares (11/30/2015)

---

Brandie Tarvin (11/30/2015)

---

Eirikur Eiriksson (11/27/2015)

---

Brandie Tarvin (11/27/2015)

---

My SO just informed me that he's learned how to write a LEFT INNER JOIN in Oracle.

And now my head is just...

Eirikur Eiriksson (11/27/2015)

---

Brandie Tarvin (11/27/2015)

---

My SO just informed me that he's learned how to write a LEFT INNER JOIN in Oracle.

And now my head is just spinning with the notion...

My SO just informed me that he's learned how to write a LEFT INNER JOIN in Oracle.

And now my head is just spinning with the notion that an INNER JOIN...

If possible, you should really make your networks local first, then move them across the network (copy) when the backup is completed. It will take less time to make the...

Help! I can't...

So I did a "small" thing (that took more time than effort) for an internal customer this morning.

About 5 minutes ago received an email with "THANK YOU" in 40 pt...

So far as I know, there is no "expected compression" because it varies by database. Do a free space check on that large DB. A quick way of doing it...

Your escape characters need escaping. @=)

ThomasRushton (11/24/2015)

---

Ed Wagner (11/23/2015)

---

I like that. Perhaps a more individualized approach would be to...

My best advice is to suspend the mirror while doing the shrinks on the primary. There's nothing really you can do for the secondary. Unless you want to break the...

I have the simplest error-handling method in the universe:

Is there an error?

DROP DATABASE <problemDB>;

Done.

It's not just you. Though, to be fair, Try...Catch probably caught...

Any shrink is going to fragment indexes. Your issue seems to be that you want to see results sooner rather than later. Also, mini-shrinks do work on larger databases without...