Jeff Moden

Forum Replies Created

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

RE: Stuck Parallel Query

Not nearly enough information. My recommendation is to download a copy of sp_WhoIsActive by Adam Machanic (Google for it, please) and find out what is running (it'll show the actual...
--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 5:24 pm

#2016045
RE: Basic Question: Do you have to restart the instance if you change database or log file growth

Maybe if I ask a third time... 😉
You say the last batch caused the file to grow so let's talk about the nature of your batches vs the rest 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 11, 2018 at 5:01 pm

#2016042
RE: Basic Question: Do you have to restart the instance if you change database or log file growth

Jeff Moden - Thursday, November 22, 2018 1:56 PM
bdkdavid - Wednesday, November 21, 2018 5:37 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 11, 2018 at 3:20 pm

#2016037
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

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