Jeff Moden

Forum Replies Created

Viewing 15 posts - 18,151 through 18,165 (of 59,069 total)

RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

TomThomson (3/12/2016)
Jeff Moden (3/12/2016)
My real concern, especially on the CONNECT posts, is the old "user wants to build a swing" engineering diagram and I hope MS doesn't screw it up...
--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)

March 12, 2016 at 10:28 pm

#1864776
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

peter-757102 (3/12/2016)
TomThomson (3/12/2016)
peter-757102 (3/12/2016)
.....
De-serialization tasks need to work exactly in reverse to the serialization, which is:
Empty array/set/list --> NULL
One empty string or ID --> ""
Two empty strings or ID --->...
--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)

March 12, 2016 at 9:38 pm

#1864774
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Hi Peter,
Good to "see" you again.
To be honest, I cannot think of a single instance where I wanted to remove zero length (or as you refer to them, NULL) elements.
As...
--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)

March 12, 2016 at 9:19 pm

#1864772
RE: PowerBI Desktop - CALENDAR() function

pietlinden (3/12/2016)
I have a working PBIX file that looks at symptom data over time, and I was trying to do the whole thing inside of PowerBI Desktop, without using SQL...
--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)

March 12, 2016 at 9:03 pm

#1864771
RE: Unable to select from function

sgreiner (3/12/2016)
I am unable to select from the following function - even though it looks like I'm doing everyting correctly and trying two different methods. The function compiles successfully.
ALTER...
--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)

March 12, 2016 at 7:25 pm

#1864769
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

TomThomson (3/12/2016)
Jeff Moden (3/12/2016)
peter-757102 (3/12/2016)
When treating NULL as an "empty string" instead of "no string" and thus return rows for it, it is going to complicate and limits its use...
--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)

March 12, 2016 at 5:30 pm

#1864767
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

You have to trust me when I say that I already know the OUTER APPLY work around so, ultimately, it doesn't matter which way they go on the NULL thing...
--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)

March 12, 2016 at 3:52 pm

#1864759
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

peter-757102 (3/12/2016)
When treating NULL as an "empty string" instead of "no string" and thus return rows for it, it is going to complicate and limits its use for serialization/de-serialization tasks...
--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)

March 12, 2016 at 2:51 pm

#1864757
RE: LIKE with 2 searches

Ed Wagner (3/11/2016)
You may already know this, but having that leading wildcard in the search will prevent SQL Server from using an index on that column, so your query is...
--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)

March 12, 2016 at 10:48 am

#1864749
RE: Parent and child relationship is broken when do the sort based on parent name

stsivaraj (3/11/2016)
Hi All,
I want to sort the name based on 1st level (sort only applicable root id is null or level ==1)....
--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)

March 12, 2016 at 10:34 am

#1864748
RE: Multiple Entris in Night Shift in SQL

hardik-1087613 (3/12/2016)
Also there will missing punch entries there like from above 10-03-2016 22:04:00 Entry will be missing.
Ok... so what needs to happen in such an instance?
--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)

March 12, 2016 at 10:24 am

#1864746
RE: Potential presentation idea: The role of documentation in disaster recovery

Ray K (3/11/2016)
I've come up with an abstract. Again, I could use some feedback.
Title: "Disaster Documents: The role of documentation in disaster recovery"
I was an employee of a company...
--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)

March 12, 2016 at 10:11 am

#1864745
RE: Shrink data file even though it is a bad practice....

Ed Wagner (3/11/2016)
I hope you're planning on doing some serious index maintenance after all this shrinking. Shrinking data files tends to fragment indexes to 99%, so it will be...
--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)

March 12, 2016 at 9:52 am

#1864744
RE: Query/Performance Tuning Steps without help of profiler

GilaMonster (3/7/2016)
Jeff Moden (3/7/2016)
Heh... I strongly agree... to disagree. 😛
You're welcome to disagree, but Profiler's deprecated and Extended Events are far better, lighter weight, more configurable and new events...
--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)

March 12, 2016 at 9:23 am

#1864743
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Solomon Rutzky (3/12/2016)
Jeff Moden (3/12/2016)
IMHO, what you have to remember is that, no matter what type of function it is, it's still "just" a string manipulation function, which makes it...
--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)

March 12, 2016 at 9:09 am

#1864742

Viewing 15 posts - 18,151 through 18,165 (of 59,069 total)