Jeff Moden

Forum Replies Created

Viewing 15 posts - 25,456 through 25,470 (of 59,102 total)

RE: Effectiveness

Steve Jones - SSC Editor (11/8/2013)
Jeff Moden (11/7/2013)
"Doing it right the first time" shouldn't be just a motto. It should be the best of all practices.
What's "right"?
What 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)

November 8, 2013 at 5:28 pm

#1665268
RE: Testing for legitimate Time data type

RedBirdOBX (11/8/2013)
This one is giving me a lot of grief!!
Check this out:
SELECT
CASE
WHEN ISDATE([InspectionTime]) = 1 THEN
CONVERT(TIME, [InspectionTime], 114)
ELSE
[InspectionTime]
END
FROM Inspection38
"InspectionTime" is a field that will contain some bad data...
--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)

November 8, 2013 at 4:54 pm

#1665255
RE: Script to Delete Reports Older than a Certain Number of Days

hisakimatama (11/8/2013)
Using xp_cmdshell may work, but it doesn't have the flexibility of Powershell.
...{snip}...
if you need file-extension filtering, I may be able to alter it as needed.
BWAAA-HAAA!!!! Too funny. ...
--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)

November 8, 2013 at 4:47 pm

#1665254
RE: Effectiveness

Nevyn (11/7/2013)
Doing it right the first time is a great motto, but when this decision is to be made, that ship has often sailed.
That's EXACTLY the problem I'm speaking 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)

November 7, 2013 at 10:44 pm

#1664995
RE: Effectiveness

If you want it real bad, that's the way you'll get it.
Rework costs at least 8 times more than doing it right the first time.
Your customers are the most important...
--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)

November 7, 2013 at 1:51 pm

#1664918
RE: Simple query maxing CPU

Ah! THERE it is! I remembered that I had an article out there somewhere where I had documented that the example code actually ran twice as slow in...
--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)

November 7, 2013 at 8:20 am

#1664799
RE: Simple query maxing CPU

SscLover (11/7/2013)
hi Jeff,
adding an index is actually the worst thing you could do even for SELECTs.
could you please enlighten us with some test samples or links would be appreciated.
The paraphrasing...
--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)

November 7, 2013 at 8:03 am

#1664785
RE: display order by like 1,2,3,4,5...............plz write quarie

dwain.c (11/6/2013)
Based on cursory review of the information surrounding the quote, I'm in a position of "initial reluctance to agree."
I'm thinking that part of that 97% he talks about should...
--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)

November 6, 2013 at 9:10 pm

#1664617
RE: display order by like 1,2,3,4,5...............plz write quarie

dwain.c (11/5/2013)
Jeff Moden (11/5/2013)
dwain.c (11/5/2013)
Jeff Moden (11/5/2013)
dwain.c (11/5/2013)
For what it's worth, I'm in favor of a selective culling of the gene pool. 😛
I assure you, it's just words from some...
--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)

November 6, 2013 at 8:37 pm

#1664613
RE: display order by like 1,2,3,4,5...............plz write quarie

I almost forgot. I misquoted the man probably because I've heard it misquoted by others so often. The actual quote should commence with "premature optimization" rather than "pre-optimization".
--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)

November 6, 2013 at 8:28 pm

#1664611
RE: display order by like 1,2,3,4,5...............plz write quarie

dwain.c (11/6/2013)
Jeff Moden (11/6/2013)
GilaMonster (11/5/2013)
Jeff Moden (11/5/2013)
I'm well aware of that. You and I have had this conversation before and I absolutely agree. I should have said "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)

November 6, 2013 at 8:02 pm

#1664609
RE: display order by like 1,2,3,4,5...............plz write quarie

GilaMonster (11/5/2013)
Jeff Moden (11/5/2013)
I'm well aware of that. You and I have had this conversation before and I absolutely agree. I should have said "and that someone 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)

November 6, 2013 at 1:05 pm

#1664554
RE: sp_OAMethod to retrieve the file attributes from a folder

Ed Wagner (11/6/2013)
jsteinbeck-618119 (11/6/2013)
Would love it if you shared them for sure... Thanks
Oops. Sorry about that. Okay, It turns out I do not have complete notes on this,...
--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)

November 6, 2013 at 1:00 pm

#1664552
RE: Tally OH! An Improved SQL 8K “CSV Splitter” Function

Just to make sure that everyone knows where I stand on this...
There is absolutely no doubt in my mind that the SQLCLR version, like the one Paul White wrote 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)

November 6, 2013 at 12:49 pm

#1664548
RE: How to Design, Build and Test a Dynamic Search Stored Procedure

dwain.c (11/6/2013)
ChrisM@home (11/6/2013)
Jeff Moden (11/5/2013)
Phil Parkin (11/5/2013)
Dwain does it again - nice article sir!
Ditto that! Nicely done, Dwain. Great explanations and revelation of code.
I'll second that - and give...
--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)

November 6, 2013 at 12:31 pm

#1664544

Viewing 15 posts - 25,456 through 25,470 (of 59,102 total)