Jeff Moden

Forum Replies Created

Viewing 15 posts - 12,046 through 12,060 (of 59,095 total)

RE: Logging options while running stored procedure

mhtanner - Thursday, June 21, 2018 2:15 AM
A simple way to get around the issue of modified_on and modified_by causing records 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)

June 21, 2018 at 8:58 am

#1994835
RE: Bureaucracy madness

I've never enjoyed working for a company that allowed Dev to Prod deployments in minutes. Too much time ends up being spent fixing stuff and too many customers are lost...
--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)

June 21, 2018 at 8:54 am

#1994834
RE: Building Test Data

robert.sterbal 56890 - Thursday, June 21, 2018 7:40 AM
kerry_hood - Thursday, June 21, 2018 3:13 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)

June 21, 2018 at 8:43 am

#1994832
RE: Taking backup with option "Disk = nul"

pdanes - Wednesday, June 20, 2018 4:29 PM
Would that have the same effect as what I'm doing? I have studied backup manuals...
--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)

June 20, 2018 at 7:13 pm

#1994756
RE: Looking for some thoughts on design for db table renaming.

p.s. It also seems like an easy thing to test. Create a new table with a computed column on it and add a million rows of fake data. See if...
--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)

June 20, 2018 at 7:06 pm

#1994755
RE: Bureaucracy madness

p.s. No matter what happens, burn NO bridges if you decide to leave or even if you decide to stay. It's a very, very small world and you may have...
--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)

June 20, 2018 at 7:03 pm

#1994754
RE: Bureaucracy madness

tzimie - Wednesday, June 20, 2018 9:26 AM
Jeff Moden - Wednesday, June 20, 2018 7:29 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)

June 20, 2018 at 6:59 pm

#1994753
RE: Building Test Data

Frank W Fulton Jr - Wednesday, June 20, 2018 5:18 PM
Jeff & Steve,
Since the two 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)

June 20, 2018 at 5:51 pm

#1994749
RE: Logging options while running stored procedure

DesNorton - Wednesday, June 20, 2018 2:20 PM
Jeff Moden - Wednesday, June 20, 2018 11:01 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)

June 20, 2018 at 5:42 pm

#1994748
RE: Logging options while running stored procedure

Chris Harshman - Wednesday, June 20, 2018 10:56 AM
Grant Fritchey - Tuesday, June 19, 2018 2:29 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)

June 20, 2018 at 11:01 am

#1994684
RE: Looking for some thoughts on design for db table renaming.

Chris Harshman - Wednesday, June 20, 2018 10:42 AM
dudekula.kareemulla - Wednesday, June 20, 2018 8:42 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)

June 20, 2018 at 10:53 am

#1994681
RE: Logging options while running stored procedure

sgmunson - Wednesday, June 20, 2018 9:22 AM
george_at_sql - Tuesday, June 19, 2018 9:15 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)

June 20, 2018 at 10:02 am

#1994675
RE: Logging options while running stored procedure

Heh... holy moly... I think I just wrote a bloody article on the subject. Guess I'll convert it and submit it. 😀
--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)

June 20, 2018 at 10:01 am

#1994674
RE: Logging options while running stored procedure

george_at_sql - Tuesday, June 19, 2018 9:15 PM
Jeff Moden - Tuesday, June 19, 2018 3:03 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)

June 20, 2018 at 9:48 am

#1994671
RE: Bureaucracy madness

Heh... been there and done that. I absolutely feel for you. It's amazing how company mergers can destroy a culture.
Have you spoken with your boss about your...
--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)

June 20, 2018 at 7:29 am

#1994634

Viewing 15 posts - 12,046 through 12,060 (of 59,095 total)