Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,306 through 13,320 (of 59,095 total)

RE: Tempdb growth

kevaburg - Tuesday, December 26, 2017 9:25 AM
Jeff Moden - Tuesday, December 26, 2017 6:55 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 26, 2017 at 10:54 am

#1973492
RE: Is the old stuff worth learning?

David.Poole - Tuesday, December 26, 2017 9:30 AM
Jeff Moden - Tuesday, December 26, 2017 6:35 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 26, 2017 at 10:45 am

#1973491
RE: Is the old stuff worth learning?

David.Poole - Tuesday, December 26, 2017 9:30 AM
Jeff Moden - Tuesday, December 26, 2017 6:35 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 26, 2017 at 10:40 am

#1973490
RE: Is the old stuff worth learning?

Doctor Who 2 - Tuesday, December 26, 2017 8:53 AM
But I think you're right that all things shiny and new doesn't always...
--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 26, 2017 at 9:11 am

#1973472
RE: How to do Parallel Query Execution in SQL Server

Eirikur Eiriksson - Tuesday, December 26, 2017 7:53 AM
Jeff Moden - Tuesday, December 26, 2017 7:21 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 26, 2017 at 9:02 am

#1973470
RE: I don't think Pivot is going to work

rick.staples - Friday, December 22, 2017 11:04 AM
I have a list of users who but time in on a daily basis, 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)

December 26, 2017 at 7:35 am

#1973436
RE: How to do Parallel Query Execution in SQL Server

anujkumar.mca - Tuesday, December 26, 2017 6:57 AM
Hey Guys,
I stuck in a situation where I need to do parallel maintenance on few...
--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 26, 2017 at 7:21 am

#1973429
RE: Want to know what process revert a change of a value in a column

imran-k - Tuesday, December 26, 2017 6:09 AM
This table is read by other processes but not get modified only by front end...
--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 26, 2017 at 7:10 am

#1973424
RE: Tempdb growth

kevaburg - Tuesday, December 26, 2017 6:33 AM
Is it possible you are returning a very (unneccessarily) large result set that is being...
--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 26, 2017 at 6:55 am

#1973422
RE: An Introduction to PowerShell for a DBA

Lynn Pettis - Thursday, December 21, 2017 9:37 AM
Sue_H - Thursday, December 21, 2017 9:25 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 26, 2017 at 6:52 am

#1973418
RE: Is the old stuff worth learning?

silvio.schurig - Tuesday, December 26, 2017 5:23 AM
I think old / new is not a major point in whether or not to...
--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 26, 2017 at 6:39 am

#1973417
RE: Is the old stuff worth learning?

David.Poole - Tuesday, December 26, 2017 2:17 AM
Every step taken, whether mistake or true, made me what I am today. The past...
--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 26, 2017 at 6:35 am

#1973416
RE: Database change documentation

DCS_JJW - Monday, March 6, 2017 9:21 AM
I am curious about what kind of database documentation is provided to you the client...
--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 26, 2017 at 6:09 am

#1973409
RE: Database change documentation

Two spam posts reported.
--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 26, 2017 at 6:07 am

#1973407
RE: Tempdb growth

haichells - Monday, December 25, 2017 10:14 PM
Hi,
I have a huge insert/update operation performing in set of tables. The process tooks almost...
--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 26, 2017 at 6:04 am

#1973406

Viewing 15 posts - 13,306 through 13,320 (of 59,095 total)