Jeff Moden

Forum Replies Created

Viewing 15 posts - 44,746 through 44,760 (of 59,101 total)

RE: Production security for developers - 'emergency' updates

I agree with what's been said, already. The paradox of "emergency changes" is that's when bad code and mistakes are most likely to happen simply because there's a rush...
--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)

March 7, 2009 at 3:00 pm

#955572
RE: Lets help the experts help themselves

Bob Hovious (3/7/2009)
Until you all get to that point, I wonder if I could run a piece of code past some of you? It's a handy technique...
--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)

March 7, 2009 at 2:43 pm

#955566
RE: Help required Urgent...!!!

Actually, it compresses it as it's saving it for both a time savings and disk storage savings right up front. And, restores are "snap" simple. I can see...
--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)

March 7, 2009 at 2:35 pm

#955562
RE: SUM calculations are not returning correct results on SQL2005

mario (3/6/2009)
thanks for the info mate...the issue was code related indeed
Two way street, please... what was that code issue and how did you fix 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)

March 7, 2009 at 2:33 pm

#955561
RE: Identifying a record n-rows from the current, on a rolling basis, in a non-contiguous data set

Thanks for the feedback, Wayne. I appreciate you taking the time as well posting your data in such a readily consumable format.
As a sidebar, even though it makes 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)

March 7, 2009 at 2:29 pm

#955560
RE: Pivot on day number of month

NY153 (3/7/2009)
Thanks again.
But I already asked, can we do it without putting 1 to 31 hard coded?
Absolutely... and, as Jules already pointed out, it will require the use of 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)

March 7, 2009 at 2:16 pm

#955556
RE: tempDB filled 140GB HDD in under 2 days?

I recently went through such a thing... for the second time...
It was simply "bad" code where a developer didn't understand the relationship between a few tables and created what amounts...
--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)

March 7, 2009 at 2:07 pm

#955553
RE: Identifying a record n-rows from the current, on a rolling basis, in a non-contiguous data set

Actually, in SQL Server 2k5, we don't need to solve the running total problem for this because it's just a ranking problem... this should do it...
;WITH
cteGroup AS
(
SELECT...
--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)

March 7, 2009 at 12:38 pm

#955537
RE: Identifying a record n-rows from the current, on a rolling basis, in a non-contiguous data set

And, sorry... the running total article I wrote is in the process of being rewritten.
--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)

March 7, 2009 at 12:23 pm

#955534
RE: Text Parsing TSQL code

Bob Hovious (3/7/2009)
I do it strictly in self-defense.
BWAA-HAA!!! Me too! Let's get together and burn some ISO's sometime! 🙂
--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)

March 7, 2009 at 11:41 am

#955529
RE: Lets help the experts help themselves

Steve Jones - Editor (3/7/2009)
I used to think we should disclose discussions from there that aren't NDA. I still think there's value in having someone summarize and put the notes...
--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)

March 7, 2009 at 11:34 am

#955527
RE: Text Parsing TSQL code

Bob Hovious (3/7/2009)
By an odd coincidence, I just did that. It doesn't seem to make a significant difference.
I just knew you would... that's one of 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)

March 7, 2009 at 10:41 am

#955512
RE: Are the posted questions getting worse?

Roy Ernest (3/7/2009)
Flash Gordon...Brings back old memories. I have never seen the series but I used to read the comics back then. Flash with the Doc. Mandrake with Luthor nd...
--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)

March 7, 2009 at 10:35 am

#955508
RE: Are the posted questions getting worse?

Lynn Pettis (3/6/2009)
Of course, there are areas where egos are strong, RBAR solutions for one (right Jeff!).
Heh... no ego there... I let the code do the talking, as all should.
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)

March 7, 2009 at 10:34 am

#955506
RE: Text Parsing TSQL code

Bob Hovious (3/6/2009)
a WHILE loop may actually perform better than a Tally table on function like these
Jeff, do you know if the size of the tally table make any...
--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)

March 7, 2009 at 9:06 am

#955483

Viewing 15 posts - 44,746 through 44,760 (of 59,101 total)