Jeff Moden

Forum Replies Created

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

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
RE: Regex in SQL

TollHouse - Sunday, May 20, 2018 1:40 PM
Greetings,
I am what you will call an accidental DBA. I was a Systems Engineer...
--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:13 pm

#1991157
RE: A Great Case for Powershell

Heh... ironically, it's not a great case unless you use it fix the underlying problem. The underlying problem is that people HAVE made direct calls to linked servers in their...
--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 2:35 pm

#1991148
RE: create temp view

jawahar11088 - Sunday, May 20, 2018 7:42 AM
No create temporary view.
I tried temporary procedure.
And???
--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 11:43 am

#1991147
RE: The SQL Saturday Thread

I've submitted the following 2 abstracts to Columbus (OH), Indianapolis, Denver, and Pittsburgh.
“Black Arts” Index Maintenance #1: How the “Best Practice” Methods are Silently Killing Performance
--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 19, 2018 at 3:09 pm

#1991128

Viewing 15 posts - 12,286 through 12,300 (of 59,095 total)
Prev
1
2
3
…
819
820
821
…
3,938
3,939
3,940
Next