Jeff Moden

Forum Replies Created

Viewing 15 posts - 13,951 through 13,965 (of 59,101 total)

RE: Should I use Insert Trigger or not?

My recommendation is that you be really careful in your trigger design. As Kevin pointed out, the trigger won't be a performance problem if you write good code and that'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)

October 26, 2017 at 11:19 am

#1965364
RE: Unstructured Data

With the idea of coming up with a "better term" for such data, I've always kept it simple... "Other Junk". When I need to be more politically correct, I call...
--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)

October 26, 2017 at 9:30 am

#1965342
RE: Update 600,000 rows in table

Ambatinr - Tuesday, October 3, 2017 12:36 PM
HiI need to update 600,000 rows in the table column with files from the...
--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)

October 26, 2017 at 9:23 am

#1965335
RE: Trying to speed up this 'GetWorkingDays' function.

lars.hesselberg 49028 - Tuesday, October 24, 2017 8:30 AM
Hi Jeff,
However, you still have the issue of a Cartesian join between the...
--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)

October 26, 2017 at 8:53 am

#1965325
RE: Join on a Substring

sgmunson - Thursday, October 26, 2017 8:39 AM
jjf410 - Wednesday, October 25, 2017 12:20 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)

October 26, 2017 at 8:48 am

#1965323
RE: Making Indexes Invisble to the Optimiser

kevaburg - Thursday, October 26, 2017 5:33 AM
"Help stop dis-information and misinformation. Stop promulgating such anecdotal recommendations."
Hi Jeff....I read through my...
--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)

October 26, 2017 at 8:44 am

#1965319
RE: Are the posted questions getting worse?

jasona.work - Thursday, October 26, 2017 6:51 AM
The downside to working from home is, if the cats decide it's the season 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)

October 26, 2017 at 8:34 am

#1965312
RE: Best DB advice - very basic and general

Sue_H - Wednesday, October 25, 2017 6:04 PM
I thought it was worth mentioning the limit per database. Having multiple databases...
--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)

October 26, 2017 at 8:18 am

#1965309
RE: Parameter Sniffing In Action

Grey Cat - Wednesday, October 25, 2017 5:29 PM
"with recompile" is one way to avoid parameter sniffing.
I think another way is using...
--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)

October 25, 2017 at 5:58 pm

#1965253
RE: Best DB advice - very basic and general

Sue_H - Wednesday, October 25, 2017 3:08 PM
tommyleo - Wednesday, October 25, 2017 2:08 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)

October 25, 2017 at 5:46 pm

#1965251
RE: Trying to speed up this 'GetWorkingDays' function.

lars.hesselberg 49028 - Tuesday, October 24, 2017 8:30 AM
Hi Jeff,
However, you still have the issue of a Cartesian join between the...
--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)

October 25, 2017 at 4:48 pm

#1965247
RE: FORMATting dates

Heh... understood and appreciated but, IMHO, the best way to decrease the chances of a Developer making mistakes is to hire good Developers instead of using tools that can cripple...
--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)

October 25, 2017 at 12:16 pm

#1965206
RE: Join on a Substring

Joe flynn - Wednesday, October 25, 2017 11:59 AM
I have a proc that runs nightly that moves data into another table.
The procedure...
--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)

October 25, 2017 at 12:10 pm

#1965201
RE: Best DB advice - very basic and general

I don't know where my post and the post of several others on this thread went but to reiterate what I wrote previously... if you value your company, this is...
--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)

October 25, 2017 at 10:41 am

#1965186
RE: How Long Before Your Database Runs Out of Space?

Joe O'Connor - Wednesday, October 25, 2017 6:35 AM
Jeff Moden - Tuesday, October 24, 2017 4:50 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)

October 25, 2017 at 10:26 am

#1965181

Viewing 15 posts - 13,951 through 13,965 (of 59,101 total)