Jeff Moden

Forum Replies Created

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

RE: Unwired for Weeks

Steve Jones - SSC Editor - Thursday, August 9, 2018 12:25 PM
Jeff Moden - Thursday, August 9,...
--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 12:12 pm

#2001293
RE: Using a CTE as a Tally Table

thisisfutile - Friday, August 10, 2018 8:09 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 10, 2018 at 11:44 am

#2001289
RE: BCP Error

Again, what are the first 4 bytes of the file? Data or 0xFFEE or ??? Also, your row termination is wonky... what do you expect "\r\0\n\0" to actually do 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)

August 10, 2018 at 11:31 am

#2001287
RE: Distributed AG with AutoSeed

SQL-DBA-01 - Friday, August 10, 2018 7:16 AM
Instead of wasting time, why don't you help other's in the forum? Is not...
--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 11:26 am

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

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