Jeff Moden

Forum Replies Created

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

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
RE: delete records in batches?? and recursive for tables

pietlinden - Thursday, December 6, 2018 9:19 PM
The whole point of doing the delete in batches is that it doesn't increase 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 7:02 am

#2015749
RE: Lax Security is Harmful for Employment

Eric M Russell - Thursday, December 6, 2018 3:39 PM
Some economists have asserted that mortgage robo-signing was partially to blame 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)

December 6, 2018 at 7:59 pm

#2015720
RE: Lax Security is Harmful for Employment

Eric M Russell - Thursday, December 6, 2018 1:15 PM
It's hard to separate the sarcasm from truth in this Onion story. :unsure:
--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 6, 2018 at 3:34 pm

#2015710
RE: MoSQL

Lynn Pettis - Thursday, December 6, 2018 9:08 AM
Comes down to using the right tool for the job.
Heh... so different size hammers....
--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 6, 2018 at 3:26 pm

#2015709

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