Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,911 through 11,925 (of 59,095 total)

RE: Who Likes NULL?

Sean Redmond - Monday, July 9, 2018 1:07 AM
chrisbray - Monday, July 9, 2018 12:48 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)

July 9, 2018 at 6:29 am

#1996767
RE: It is possible to create a dynamic table from a result set ?

Eirikur Eiriksson - Sunday, July 8, 2018 9:28 AM
Jeff Moden - Sunday, July 8, 2018 9:11 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)

July 8, 2018 at 2:17 pm

#1996709
RE: Avoid bulk data export

Eirikur Eiriksson - Sunday, July 8, 2018 1:53 AM
frederico_fonseca - Sunday, July 8, 2018 1:17 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)

July 8, 2018 at 11:29 am

#1996706
RE: It is possible to create a dynamic table from a result set ?

Pretty cool, Eirikur. And, "Look Ma!!!!", it's fully documented! This thread is now a part of my briefcase!
You should write an article about this bad boy. 😉
--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)

July 8, 2018 at 9:11 am

#1996700
RE: Difference between minimum and maximum value

jcelko212 32090 - Friday, July 6, 2018 10:08 AM
Jeff Moden - Thursday, July 5, 2018 9:44 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)

July 8, 2018 at 8:47 am

#1996698
RE: STRING_SPLIT()

Eirikur Eiriksson - Sunday, July 8, 2018 12:45 AM
The alleged "correct" answer is wrong.
😎
What version of SQL Server did you test...
--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)

July 8, 2018 at 7:27 am

#1996686
RE: STRING_SPLIT()

Steve Jones - SSC Editor - Saturday, July 7, 2018 11:21 AM
Comments posted to this topic are about the item STRING_SPLIT()
I...
--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)

July 7, 2018 at 6:28 pm

#1996671
RE: Who Likes NULL?

Dennis Q Miller - Saturday, July 7, 2018 9:24 AM
So, NULL is a value for something that doesn't have a value? ...
--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)

July 7, 2018 at 9:59 am

#1996662
RE: Importing Tricky CSV Files with PowerShell

Bruin - Friday, July 6, 2018 12:04 PM
Does the order of the csv have to match sql schema and what about if...
--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)

July 7, 2018 at 9:41 am

#1996659
RE: Programatically change the time of a schedule

Thom A - Saturday, July 7, 2018 4:30 AM
Jeff Moden - Friday, July 6, 2018 7:09 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)

July 7, 2018 at 9:39 am

#1996658
RE: SQL design question.

hcareinfosys.jgv - Friday, July 6, 2018 3:03 PM
Thank you all for your replies. I was concerned about in the off chance I...
--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)

July 6, 2018 at 9:28 pm

#1996642
RE: Programatically change the time of a schedule

Guy Bloch - Friday, July 6, 2018 2:17 PM
Hello All,
We are using ssrs 2016..
We have approx 20 different schedules.
The Daily one for...
--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)

July 6, 2018 at 7:09 pm

#1996641
RE: Can I run a VBS script in a scheduled SQL Job?

Alejandro Santana - Friday, July 6, 2018 11:49 AM
I think using the SQL Server Agent to run stuff that don't belong...
--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)

July 6, 2018 at 1:20 pm

#1996622
RE: Ola Hallengren's Maintenance question

sqlfriends - Friday, July 6, 2018 9:54 AM
She is working to setup a content manage system with a vendor off hour. 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)

July 6, 2018 at 12:08 pm

#1996600
RE: Dilemma between Microsoft BI developer or Application Developer

j1devop - Wednesday, July 4, 2018 8:57 PM
I find myself literally the same situation - wondering which direction was taken.
Like Yogi Berra said, "When...
--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)

July 6, 2018 at 8:39 am

#1996554

Viewing 15 posts - 11,911 through 11,925 (of 59,095 total)