Jeff Moden

Forum Replies Created

Viewing 15 posts - 14,236 through 14,250 (of 59,097 total)

RE: We Have a Date

jasona.work - Thursday, September 28, 2017 1:44 PM
Thom A - Thursday, September 28, 2017 11:39 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)

September 28, 2017 at 4:09 pm

#1961493
RE: We Have a Date

jasona.work - Thursday, September 28, 2017 10:47 AM
Sean Lange - Thursday, September 28, 2017 10: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)

September 28, 2017 at 4:07 pm

#1961492
RE: Code-first vs database-first, any new developments?

Phil Parkin - Wednesday, September 27, 2017 9:17 AM
Jeff Moden - Wednesday, September 27, 2017 9:09 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)

September 28, 2017 at 3:59 pm

#1961490
RE: Import question

jeremy.schillinger - Wednesday, September 27, 2017 12:01 PM
I am importing data from a 3rd party system into a DB that I 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)

September 27, 2017 at 1:28 pm

#1961236
RE: Naming Conventions - Table and Column Names

I agree with the idea of avoiding both spaces and underscores for most things. Avoiding spaces should be a "commandment". As with spaces, I don't ever use underscores to merely...
--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)

September 27, 2017 at 9:35 am

#1961185
RE: Trim off trailing letters

John Mitchell-245523 - Wednesday, September 27, 2017 2:28 AM
"In a format we can consume" means we can just run the code and...
--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)

September 27, 2017 at 9:29 am

#1961182
RE: diff backup during full backup

tony28 - Wednesday, September 27, 2017 1:26 AM
Hello,
I have only question for thinking.
if you have full backup which is sometimes more than...
--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)

September 27, 2017 at 9:24 am

#1961179
RE: Code-first vs database-first, any new developments?

chuck.forbes - Monday, September 25, 2017 2:51 PM
I'm discussing this topic with a developer, and I'm also performing due diligence and looking...
--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)

September 27, 2017 at 9:09 am

#1961171
RE: XP_CMDSHELL fails execution

Hany Helmy - Wednesday, September 27, 2017 2:31 AM
Hi,
Please note that when xp_cmdshell is called by a user that is not a member 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)

September 27, 2017 at 8:47 am

#1961163
RE: Are the posted questions getting worse?

GilaMonster - Tuesday, September 26, 2017 3:09 PM
Jeff Moden - Tuesday, September 26, 2017 2:53 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)

September 26, 2017 at 3:44 pm

#1961067
RE: Are the posted questions getting worse?

Lynn Pettis - Tuesday, September 26, 2017 3:04 PM
Must have missed that warning about the "illegal" form of UPDATE.
It's a JOINed...
--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)

September 26, 2017 at 3:33 pm

#1961065
RE: Are the posted questions getting worse?

Phil Parkin - Tuesday, September 26, 2017 11:56 AM
Jeff Moden - Tuesday, September 26, 2017 11:44 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)

September 26, 2017 at 2:53 pm

#1961059
RE: Are the posted questions getting worse?

jonathan.crawford - Tuesday, September 26, 2017 10:30 AM
Luis Cazares - Tuesday, September 26, 2017 8: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)

September 26, 2017 at 11:44 am

#1961026
RE: Are the posted questions getting worse?

Jason A. Long - Saturday, September 23, 2017 5:31 PM
Entity Framework & LINQ...
recently talked to a company who is looking...
--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)

September 25, 2017 at 5:48 pm

#1960871
RE: Concatenate sp_MSForeachdb results

patrickmcginnis59 10839 - Monday, September 25, 2017 11:50 AM
Jeff Moden - Tuesday, September 19, 2017 6:10 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)

September 25, 2017 at 12:02 pm

#1960825

Viewing 15 posts - 14,236 through 14,250 (of 59,097 total)