Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,411 through 10,425 (of 59,099 total)

RE: An Overview of STRING_SPLIT()

Jason A. Long - Tuesday, December 11, 2018 1:05 AM
Jeff Moden - Monday, December 10, 2018 11:58...
--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)

December 11, 2018 at 8:32 am

#2015994
RE: An Overview of STRING_SPLIT()

Lot's of people have been doing that trick with RowNumber. Thinking about the code behind the scenes, it should be guaranteed but MS refuses to state that...
--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)

December 10, 2018 at 11:58 pm

#2015964
RE: Logical Drives on a Solid State Platter

rchantler - Monday, December 10, 2018 2:54 PM
Andy DBA - Monday, December 10, 2018 2:33 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)

December 10, 2018 at 8:27 pm

#2015956
RE: An Overview of STRING_SPLIT()

Eirikur Eiriksson - Monday, December 10, 2018 9:09 AM
Jeff Moden - Monday, December 10, 2018 8:24 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)

December 10, 2018 at 12:15 pm

#2015931
RE: Run away logical reads on stored proc causing timeouts.

Eric M Russell - Monday, December 10, 2018 10:36 AM
sgmunson - Monday, December 10, 2018 8:41 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)

December 10, 2018 at 11:46 am

#2015923
RE: An Overview of STRING_SPLIT()

Eirikur Eiriksson - Monday, December 10, 2018 9:09 AM
AB's article isn't bad but it's incomplete and hasn't been appropriately updated.
--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)

December 10, 2018 at 9:40 am

#2015902
RE: Loading CSV Files Using Dynamic SQL

You're welcome. I also neglected to state that the test data consisted of 1 million rows with 2 non-LOB columns and 1 VARCHAR(MAX) column and total table size was 572MB. It was...
--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)

December 10, 2018 at 8:42 am

#2015886
RE: An Overview of STRING_SPLIT()

Steve Jones - SSC Editor - Monday, December 10, 2018 7:03 AM
philcart - Sunday, December 9, 2018...
--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)

December 10, 2018 at 8:24 am

#2015879
RE: Issues with filling in the blanks from a calendar table.

Y.B. - Monday, December 10, 2018 8:01 AM
I'm converting my datetimes to time since I want to get data in 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)

December 10, 2018 at 8:12 am

#2015876
RE: Entity-Attribute-Value is evil ? how to avoid...

carlo.pagliei 63874 - Saturday, December 8, 2018 2:47 AM
Yesterday I had an interesting talk with a guy that adopt the following solution:...
--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)

December 10, 2018 at 8:09 am

#2015875
RE: Loading CSV Files Using Dynamic SQL

Sean Redmond - Monday, December 10, 2018 6:07 AM
I'm preparing a pilot-study on Full-Text Search and this script will go part of...
--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)

December 10, 2018 at 7:56 am

#2015873
RE: how to select not null values?

Sorry... misread the code. Deleted my reply.
--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)

December 7, 2018 at 5:17 pm

#2015809
RE: Finding the database

MS has many system stored procedures that us it so you can pass in 'somenondboschemaname.sometablename'. For example, sp_rename uses it and you can pass in up to a 4 part...
--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)

December 7, 2018 at 5:12 pm

#2015808
RE: Perfmon

I didn't select any of the answers because I save my perfmon settings and reference them in the ICON that I have setup on the desktop. If I want 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)

December 7, 2018 at 10:45 am

#2015790
RE: Logical Drives on a Solid State Platter

rchantler - Friday, December 7, 2018 7:47 AM
In the olden days we meticulously separated the system files from data files from log...
--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)

December 7, 2018 at 10:36 am

#2015789

Viewing 15 posts - 10,411 through 10,425 (of 59,099 total)