Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,096 through 13,110 (of 59,099 total)

RE: Need to convert lowercase characters to 'a' and uppercase to 'A'

srikanthrv - Friday, January 19, 2018 6:24 AM
Hi,
I have a requirement to anonymise the data in table by replacing all the lowercase...
--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)

January 19, 2018 at 9:59 am

#1976537
RE: Running out of space on Server OS drive, where SQL Server app located, what to clear out?

Perry Whittle - Friday, January 19, 2018 4:51 AM
Jeff Moden - Tuesday, January 16, 2018 11:23 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)

January 19, 2018 at 7:22 am

#1976505
RE: identify missing index for query

ChrisM@Work - Friday, January 19, 2018 5:18 AM
Grant Fritchey - Friday, January 19, 2018 5:10 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)

January 19, 2018 at 7:19 am

#1976503
RE: Are the posted questions getting worse?

ChrisM@Work - Friday, January 19, 2018 6:26 AM
You guys have caused quite a stir here.
Heh... I have to "blame" it all on Brent. ...
--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)

January 19, 2018 at 7:13 am

#1976500
RE: Are the posted questions getting worse?

jasona.work - Friday, January 19, 2018 5:58 AM
Well, I know I'm going.
Looking forward to it, Jason. Tell others because we're definitely...
--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)

January 19, 2018 at 7:06 am

#1976498
RE: Are the posted questions getting worse?

ChrisM@Work - Friday, January 19, 2018 6:26 AM
Ed Wagner - Friday, January 19, 2018 6:01 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)

January 19, 2018 at 6:48 am

#1976492
RE: Are the posted questions getting worse?

Hugo Kornelis - Friday, January 19, 2018 3:42 AM
Jeff Moden - Thursday, January 18, 2018 4:35 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)

January 19, 2018 at 6:42 am

#1976491
RE: UPDATE() function in a trigger

TheSQLGuru - Thursday, January 18, 2018 10:04 PM
Jeff Moden - Thursday, January 18, 2018 8:27 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)

January 18, 2018 at 10:41 pm

#1976451
RE: Are the posted questions getting worse?

Lynn Pettis - Thursday, January 18, 2018 8:26 PM
Jeff Moden - Thursday, January 18, 2018 5:16 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)

January 18, 2018 at 10:21 pm

#1976450
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor - Thursday, January 18, 2018 10:55 AM
Lynn Pettis - Thursday, January 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)

January 18, 2018 at 5:18 pm

#1976436
RE: Are the posted questions getting worse?

Lynn Pettis - Thursday, January 18, 2018 9:01 AM
Jeff, Kevin Tate was doing a SQL Server Indexing 101 at our user group...
--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)

January 18, 2018 at 5:16 pm

#1976435
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor - Thursday, January 18, 2018 10:53 AM
Jeff Moden - Thursday, January 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)

January 18, 2018 at 4:35 pm

#1976432
RE: Formatted ASCII Results from a SELECT

Eric M Russell - Thursday, January 18, 2018 12:37 PM
Jeff Moden - Thursday, January 18, 2018 10:16...
--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)

January 18, 2018 at 1:28 pm

#1976416
RE: It's Not Yours

jasona.work - Thursday, January 18, 2018 10:14 AM
Eric M Russell - Thursday, January 18, 2018 7:46 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)

January 18, 2018 at 10:18 am

#1976377
RE: Formatted ASCII Results from a SELECT

Eric M Russell - Thursday, January 18, 2018 8:37 AM
Jeff, you should run for president (of the American National Standards Institute).
Heh... you...
--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)

January 18, 2018 at 10:16 am

#1976376

Viewing 15 posts - 13,096 through 13,110 (of 59,099 total)