Jeff Moden

Forum Replies Created

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

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
RE: How Long Before Your Database Runs Out of Space?

Joe O'Connor - Wednesday, October 25, 2017 9:47 AM
KenpoDBA - Wednesday, October 25, 2017 8: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)

October 25, 2017 at 10:17 am

#1965178
RE: script to verify index fragmentation

river1 - Wednesday, October 25, 2017 8:12 AM
I added the word indexstats.
--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 8:56 am

#1965156

RE: FORMATting dates

TomThomson - Wednesday, October 25, 2017 4:30 AM

Steve Jones - SSC Editor - Tuesday, October 24, 2017...

--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 8:07 am

#1965143

RE: script to verify index fragmentation

IF you believe that index fragmentation is actually a problem then, without question, one of the best there is was written by and is maintained by a fellow by the...

--Jeff Moden

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 7:58 am

#1965138