Viewing 15 posts - 2,116 through 2,130 (of 9,715 total)
Steve Jones - SSC Editor (12/2/2015)
select col
from table
where name = x;
and color = 'red'
And I get a syntax error and my eyes...
December 2, 2015 at 10:32 am
robert.sterbal 56890 (11/30/2015)
robert.sterbal 56890 (11/30/2015)
Images:Search:
https://www.google.com/search?q=venn+diagram+left+outer+join
It is redundant, but is used quite frequently:
Nice link. Thanks, Robert.
Heehee.
December 1, 2015 at 5:37 am
Luis Cazares (11/30/2015)
Brandie Tarvin (11/30/2015)
Eirikur Eiriksson (11/27/2015)
Brandie Tarvin (11/27/2015)
And now my head is just...
November 30, 2015 at 6:41 am
Eirikur Eiriksson (11/27/2015)
Brandie Tarvin (11/27/2015)
And now my head is just spinning with the notion...
November 30, 2015 at 5:52 am
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...
November 27, 2015 at 12:06 pm
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...
November 27, 2015 at 12:00 pm
Lynn Pettis (11/25/2015)
Help, I can't read and don't know how to attach a file... Sorry, some people are finding it easier to push my buttons today.
Help! I can't...
November 25, 2015 at 11:32 am
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...
November 25, 2015 at 9:23 am
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...
November 25, 2015 at 7:43 am
Your escape characters need escaping. @=)
November 24, 2015 at 11:26 am
ThomasRushton (11/24/2015)
Ed Wagner (11/23/2015)
Brandie Tarvin (11/23/2015)
I have the simplest error-handling method in the universe:Is there an error?
DROP DATABASE <problemDB>;
Done.
I like that. Perhaps a more individualized approach would be to...
November 24, 2015 at 6:18 am
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...
November 23, 2015 at 10:19 am
I have the simplest error-handling method in the universe:
Is there an error?
DROP DATABASE <problemDB>;
Done.
November 23, 2015 at 9:15 am
Luis Cazares (11/23/2015)
Is it me or many people don't really understand error handling or why and how to use try...catch...?
It's not just you. Though, to be fair, Try...Catch probably caught...
November 23, 2015 at 9:05 am
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...
November 23, 2015 at 9:02 am
Viewing 15 posts - 2,116 through 2,130 (of 9,715 total)