Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,286 through 12,300 (of 59,099 total)

RE: Are the posted questions getting worse?

Steve Jones - SSC Editor - Monday, May 21, 2018 8:20 AM
Jeff Moden - Friday, May 18,...
--Jeff Moden
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.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 21, 2018 at 10:16 am

#1991288
RE: The SQL Saturday Thread

Ray K - Sunday, May 20, 2018 6:37 PM
Jeff Moden - Saturday, May 19, 2018 3:08 PM
--Jeff Moden
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.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 21, 2018 at 9:59 am

#1991282
RE: The SQL Saturday Thread

Steve Jones - SSC Editor - Monday, May 21, 2018 9:12 AM
Heading the SQL Sat LA in a few weeks.
The only other...
--Jeff Moden
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.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 21, 2018 at 9:52 am

#1991276
RE: In what twisted SQL world will a JOIN result in more records than a LEFT JOIN

Heh... Moderators? 😀
I wouldn't delete this thread if I could. It has a lot of good thoughts in it including the thought that sometimes things happen that might...
--Jeff Moden
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.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 21, 2018 at 7:45 am

#1991221
RE: Regex in SQL

TollHouse - Monday, May 21, 2018 6:45 AM
We see the issue with mobile deposit and the check is being read from a...
--Jeff Moden
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.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 21, 2018 at 6:59 am

#1991207
RE: create temp view

ThomasRushton - Monday, May 21, 2018 3:05 AM
Jeff Moden - Sunday, May 20, 2018 11:43 AM
--Jeff Moden
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.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 21, 2018 at 6:45 am

#1991204
RE: updating sql via excel.

sunilchand - Monday, May 21, 2018 6:29 AM
snomadj - Monday, May 21, 2018 3:31 AM
--Jeff Moden
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.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 21, 2018 at 6:40 am

#1991202
RE: A Great Case for Powershell

call.copse - Monday, May 21, 2018 3:22 AM
Fair point Jeff, but who would pay us if everyone knew how to do everything...
--Jeff Moden
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.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 21, 2018 at 6:02 am

#1991190
RE: Are the posted questions getting worse?

I whacked 4 spam generating users last night... right after I saw Tom's email.
Still, this junk should never be making it to the forums. There should be some...
--Jeff Moden
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.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 21, 2018 at 5:56 am

#1991189
RE: Regex in SQL

frederico_fonseca - Monday, May 21, 2018 1:21 AM
Steve,
As far as I can see its not Luhn 10 checksum but rather processing the...
--Jeff Moden
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.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 21, 2018 at 5:53 am

#1991188
RE: Restoring database A also tries to Restore database B

I'm not seeing anything obvious in that, either. Sorry... not much help here.
--Jeff Moden
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.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 20, 2018 at 8:24 pm

#1991164
RE: Storing multiple variations of the same data?

aaron.reese - Friday, May 18, 2018 9:49 AM
The design pattern is to achieve one or more of the following, some of which...
--Jeff Moden
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.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 20, 2018 at 8:08 pm

#1991163
RE: Change formatting of SSMS generated code

autoexcrement - Friday, May 18, 2018 11:34 PM
I'm in the San Francisco area, but planning to travel to Michigan next year. Maybe...
--Jeff Moden
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.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 20, 2018 at 7:49 pm

#1991162
RE: How do you keep yourself from burning out?

TomThomson - Sunday, May 20, 2018 6:58 PM
Somehow I can't connect burnout with long hours - maybe that's because most of my...
--Jeff Moden
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.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 20, 2018 at 7:36 pm

#1991160
RE: Regex in SQL

TollHouse - Sunday, May 20, 2018 7:14 PM
Thank you Frederico for the information. I have heard of R server but never thought...
--Jeff Moden
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.
Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

May 20, 2018 at 7:33 pm

#1991159

Viewing 15 posts - 12,286 through 12,300 (of 59,099 total)