Viewing 15 posts - 5,071 through 5,085 (of 9,400 total)
Jacob Wilkins (9/24/2015)
mw112009 (9/24/2015)
Beleive me, the LEFT OUTER JOIN is faster.I deal with large tables and the "EXITS" make the query run for hours..
You likely have something else at play...
September 25, 2015 at 5:23 am
DonlSimpson (9/24/2015)
Ed Wagner (9/24/2015)
Revenant (9/24/2015)
SQLRNNR (9/24/2015)
whereisSQL? (9/24/2015)
Eirikur Eiriksson (9/24/2015)
SQLRNNR (9/24/2015)
camptownSlum
Dog
millionaire
game show
Jeopardy
SNL
da Bears
September 25, 2015 at 5:19 am
GilaMonster (9/24/2015)
sql-lover (9/24/2015)
Not sure if HxD can open a DIFF backup.
Why would it not be able to? Hex editors don't care about the file type, they display the files they...
September 24, 2015 at 1:32 pm
I prefer the EXISTS approach instead of the OUTER JOIN/IS NULL approach. I think it's much clearer.
September 24, 2015 at 1:29 pm
Eric M Russell (9/24/2015)
Luis Cazares (9/24/2015)
I'd go up to four. 😎
Careful, when the servers finally do come back online, hopefully the database team won't be slumped face down on their...
September 24, 2015 at 1:27 pm
Revenant (9/24/2015)
SQLRNNR (9/24/2015)
whereisSQL? (9/24/2015)
Eirikur Eiriksson (9/24/2015)
SQLRNNR (9/24/2015)
camptownSlum
Dog
millionaire
game show
Jeopardy
September 24, 2015 at 1:23 pm
whereisSQL? (9/24/2015)
Ed Wagner (9/24/2015)
whereisSQL? (9/24/2015)
Eirikur Eiriksson (9/24/2015)
SQLRNNR (9/24/2015)
camptownSlum
Dog
Guard
Thief
Night
September 24, 2015 at 11:48 am
whereisSQL? (9/24/2015)
Eirikur Eiriksson (9/24/2015)
SQLRNNR (9/24/2015)
camptownSlum
Dog
Guard
September 24, 2015 at 10:23 am
anthony.green (9/24/2015)
Ed Wagner (9/24/2015)
anthony.green (9/24/2015)
BWFC (9/24/2015)
djj (9/24/2015)
Stuart Davies (9/24/2015)
Eirikur Eiriksson (9/23/2015)
SQLRNNR (9/23/2015)
gossipWhisper
Careless
Lawless
Bandit
one armed
Gambling
!!WINNING!! (in my best Charlie Sheen impression)
Effort
September 24, 2015 at 6:52 am
anthony.green (9/24/2015)
BWFC (9/24/2015)
djj (9/24/2015)
Stuart Davies (9/24/2015)
Eirikur Eiriksson (9/23/2015)
SQLRNNR (9/23/2015)
gossipWhisper
Careless
Lawless
Bandit
one armed
Gambling
September 24, 2015 at 6:05 am
Maybe reading the requirements is a part of the question. The "count of subjects" is different than the "count of distinct subjects". So very many times in work,...
September 24, 2015 at 5:38 am
BWFC (9/24/2015)
SQLRNNR (9/23/2015)
Steve Jones - SSC Editor (9/23/2015)
BWFC (9/23/2015)
Promotion today :w00t: Yay me!!!!Congrats. With a raise?
If no raise, then let them keep the promotion.
Love the promotions where it is only...
September 24, 2015 at 5:25 am
SQLRNNR (9/23/2015)
Eirikur Eiriksson (9/23/2015)
WayneS (9/23/2015)
Eirikur Eiriksson (9/23/2015)
SQLRNNR (9/23/2015)
Eirikur Eiriksson (9/23/2015)
This made me giggle*cough*:cool:
Come on Jason, don't be shy, pitch one of your good comments:-P in here, I've only done few...
September 23, 2015 at 12:03 pm
Eirikur Eiriksson (9/23/2015)
SQLRNNR (9/23/2015)
Eirikur Eiriksson (9/23/2015)
This made me giggle*cough*:cool:
Come on Jason, don't be shy, pitch one of your good comments:-P in here, I've only done few millions (£) worth of...
September 23, 2015 at 11:46 am
Alvin Ramard (9/23/2015)
Luis Cazares (9/23/2015)
Manic Star (9/23/2015)
patricklambin (9/23/2015)
Stewart "Arturius" Campbell (9/22/2015)
Interesting question, thanks SteveAnother of the functions copied from Excel.
I don't think so. These functions have been introduced only to...
September 23, 2015 at 8:33 am
Viewing 15 posts - 5,071 through 5,085 (of 9,400 total)