Viewing 15 posts - 11,011 through 11,025 (of 59,099 total)
--Jeff Moden
Change is inevitable... Change for the better is not.
October 10, 2018 at 6:11 am
Heh.... on the humorous side, I'd say both words were appropriate considering some of the DBA candidates I've interviewed where I was left wondering how they managed to administer anything....
--Jeff Moden
Change is inevitable... Change for the better is not.
October 9, 2018 at 10:27 pm
I know this is a common problem but I just don't see how folks...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 9, 2018 at 10:16 pm
And I disagree with NOLOCK being useless (although it should be WITH (NOLOCK)). It does have its uses.
--Jeff Moden
Change is inevitable... Change for the better is not.
October 9, 2018 at 10:09 pm
VARCHAR(1) or NVARCHAR(1) (or most anything less than 10 characters but especially for 1 character.
WHERE ISNULL(somecolumn,0) > 0
WHERE somecolumn IS NOT NULL AND somecolumn > '...
--Jeff Moden
Change is inevitable... Change for the better is not.
October 9, 2018 at 10:05 pm
--Jeff Moden
Change is inevitable... Change for the better is not.
October 9, 2018 at 9:33 pm
--Jeff Moden
Change is inevitable... Change for the better is not.
October 9, 2018 at 9:05 pm
--Jeff Moden
Change is inevitable... Change for the better is not.
October 9, 2018 at 8:59 pm
--Jeff Moden
Change is inevitable... Change for the better is not.
October 9, 2018 at 8:28 am
Just in case anyone missed it... even the Gods of Google aren't gods. Worse yet, they covered it up. Some companies have just gotten too big for the britches. --Jeff Moden Change is inevitable... Change for the better is not.
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
October 9, 2018 at 7:34 am
--Jeff Moden
Change is inevitable... Change for the better is not.
October 9, 2018 at 7:24 am
--Jeff Moden
Change is inevitable... Change for the better is not.
October 9, 2018 at 7:13 am
--Jeff Moden
Change is inevitable... Change for the better is not.
October 9, 2018 at 7:13 am
--Jeff Moden
Change is inevitable... Change for the better is not.
October 8, 2018 at 8:49 pm
--Jeff Moden
Change is inevitable... Change for the better is not.
October 8, 2018 at 8:36 pm
Viewing 15 posts - 11,011 through 11,025 (of 59,099 total)