Jeff Moden

Forum Replies Created

Viewing 15 posts - 11,566 through 11,580 (of 59,095 total)

RE: Are the posted questions getting worse?

Phil Parkin - Friday, August 10, 2018 6:37 AM
Jeff Moden - Friday, August 10, 2018 6:32 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)

August 10, 2018 at 7:14 am

#2001220
RE: Distributed AG with AutoSeed

SQL-DBA-01 - Friday, August 10, 2018 6:38 AM
Then why are you wasting your time? I never had seen you solving other's...
--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)

August 10, 2018 at 7:10 am

#2001216
RE: Partioning Huge Table (650GB about)

Rosanero4Ever - Thursday, August 9, 2018 4:56 AM
andycadley - Tuesday, August 7, 2018 10:59 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)

August 10, 2018 at 6:35 am

#2001196
RE: Are the posted questions getting worse?

I personally blackballed that monstrosity a long time ago.
--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)

August 10, 2018 at 6:32 am

#2001193
RE: Distributed AG with AutoSeed

SQL-DBA-01 - Thursday, August 9, 2018 8:52 AM
SQL-DBA-01 - Thursday, August 9, 2018 8:51 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)

August 10, 2018 at 6:30 am

#2001191
RE: DB Autogrowth

SQL Adventurar - Thursday, August 9, 2018 5:56 PM
DHeath - Wednesday, August 8, 2018 3:07 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)

August 10, 2018 at 6:22 am

#2001188
RE: Unwired for Weeks

GeorgeCopeland - Thursday, August 9, 2018 11:58 AM
Productivity falls off quickly after 40 hours and workaholics are not nearly so productive...
--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)

August 9, 2018 at 12:15 pm

#2001124
RE: DB Autogrowth

NewBornDBA2017 - Thursday, August 9, 2018 9:09 AM
Jeff Moden - Wednesday, August 8, 2018 2:58 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)

August 9, 2018 at 12:08 pm

#2001120
RE: Unwired for Weeks

jay-h - Thursday, August 9, 2018 11:19 AM
I was thinking more about someone covering when you were out for whatever reason....
--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)

August 9, 2018 at 12:02 pm

#2001118
RE: Unwired for Weeks

Steve Jones - SSC Editor - Thursday, August 9, 2018 10:58 AM
We're not saving babies is the expression that the work doesn't...
--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)

August 9, 2018 at 11:59 am

#2001117
RE: Unwired for Weeks

jay-h - Thursday, August 9, 2018 10:44 AM
Any entity in the 'saving babies' business MUST have sufficient redundancy. People are unexpectedly...
--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)

August 9, 2018 at 11:15 am

#2001103
RE: Unwired for Weeks

GeorgeCopeland - Thursday, August 9, 2018 9:21 AM
Wow Jeff, just wow. Great post.
Btw, not saving babies is a quote from you know...
--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)

August 9, 2018 at 11:07 am

#2001099
RE: Using a CTE as a Tally Table

BluePeter - Thursday, August 9, 2018 8:38 AM
Jeff Moden - Thursday, August 9, 2018 8:22 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)

August 9, 2018 at 11:03 am

#2001096
RE: Eval function TSql

Use a CASE of IIF expression.
SELECT IsEqual = CASE
--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)

August 9, 2018 at 8:44 am

#2001037

RE: Unwired for Weeks

GeorgeCopeland - Thursday, August 9, 2018 7:18 AM
We are not saving babies!

Hmmmphhh.... a long time ago, I used to think the same...

--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)

August 9, 2018 at 8:41 am

#2001035

Viewing 15 posts - 11,566 through 11,580 (of 59,095 total)