Jeff Moden

Forum Replies Created

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

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
RE: sp_OAMethod to retrieve the file attributes from a folder

jsteinbeck-618119 (11/5/2013)
Hi,
Your code would need to co-exist in my trigger l posted earlier...
I could use your to create and inline table function and pass in the location and file name......
--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 5, 2013 at 2:14 pm

#1664258
RE: SQLCMD

SQLRNNR (11/5/2013)
Jeff Moden (11/5/2013)
Heh... I had to think about it. For me, the correct answer would have started with "Exec xp_CmdShell". 😀
not sp_configure??
:w00t::-D
Heck no. I leave xp_CmdShell on...
--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 5, 2013 at 2:11 pm

#1664253
RE: Wrestling with DateTime data from SQL Sever 2000/2005 DB

RedBirdOBX (11/5/2013)
Resolved. Thanks
Please post your resolution so that others might benefit. Thanks.
--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 5, 2013 at 2:05 pm

#1664251

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