Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,246 through 13,260 (of 59,101 total)

RE: OPENROWSET when Excel worksheet name is unknown

aaron.reese - Thursday, January 4, 2018 3:47 AM
Jeff,
Are you planning to speak at any European conference this year (SQL Bits?) I would...
--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 4, 2018 at 6:09 am

#1974437
RE: What is your typical day like?

RandomStream - Wednesday, January 3, 2018 8:28 PM
I will leave the booking writing to others. Just being bored at work and wonder...
--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 4, 2018 at 5:59 am

#1974434
RE: What is your typical day like?

Heh...
Some days it's "Veni, vidi, vici".
Other days it's "Veni, vidi, W-T-F !!!???"
This and your other question (so far) seem to be "survey" questions. What is the purpose...
--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 3, 2018 at 8:10 pm

#1974381
RE: Have you experienced a serious data breach as a DBA?

I'd be surprised if anyone answered this request with an actual example. If it happened to someone, they're already embarrassed enough.
--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 3, 2018 at 7:59 pm

#1974379
RE: Rounding a numeric value to nearest integer

Lynn Pettis - Wednesday, January 3, 2018 6:58 PM
Jeff Moden - Wednesday, January 3, 2018 6:29 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 3, 2018 at 7:39 pm

#1974378
RE: Rounding a numeric value to nearest integer

Lynn Pettis - Wednesday, January 3, 2018 2:00 PM
Maybe this will shed some light on the subject:

DECLARE @testnum DECIMAL(18,2);
SET @testnum...
--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 3, 2018 at 6:29 pm

#1974375
RE: OPENROWSET when Excel worksheet name is unknown

Hansiehans - Wednesday, January 3, 2018 3:25 AM
Jeff Moden - Saturday, December 23, 2017 8:29 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 3, 2018 at 5:05 pm

#1974369
RE: An Introduction to PowerShell for a DBA

Alex Chamchourine - Wednesday, January 3, 2018 3:50 PM
Jeff Moden - Wednesday, January 3, 2018 3:23 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 3, 2018 at 5:00 pm

#1974368
RE: Creating multiple Rows from one row by substringing a column

lsinoff - Tuesday, January 2, 2018 9:33 PM
I need to create from 1 to n rows from a single row where the one...
--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 3, 2018 at 3:56 pm

#1974364
RE: An Introduction to PowerShell for a DBA

Alex Chamchourine - Wednesday, January 3, 2018 2:29 PM
Caruncles - Wednesday, January 3, 2018 8:34 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 3, 2018 at 3:23 pm

#1974362
RE: An Introduction to PowerShell for a DBA

kevaburg - Wednesday, January 3, 2018 12:07 AM
Alex Chamchourine - Tuesday, January 2, 2018 11:53 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 3, 2018 at 3:21 pm

#1974360
RE: Is there a way to identify dynamic sql that may be vulnerable to sql injection?

GilaMonster - Wednesday, January 3, 2018 12:07 PM
Thom A - Wednesday, January 3, 2018 11:47 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 3, 2018 at 3:12 pm

#1974359
RE: Find a string with two dots

khpcbgnt - Tuesday, January 2, 2018 5:06 AM
Hi ,
I have two values 13.4. and 16.8.7 in a field that is varchar type....
--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 3, 2018 at 3:06 pm

#1974357
RE: Are the posted questions getting worse?

jasona.work - Wednesday, January 3, 2018 10:34 AM
Greg Edwards-268690 - Wednesday, January 3, 2018 10:16 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 3, 2018 at 12:32 pm

#1974321
RE: Is the old stuff worth learning?

Eric M Russell - Wednesday, January 3, 2018 12:01 PM
We have come full circle, sharing time and the same decades old problems...
--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 3, 2018 at 12:29 pm

#1974320

Viewing 15 posts - 13,246 through 13,260 (of 59,101 total)