Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,336 through 43,350 (of 59,102 total)

RE: HOW TO AVOID FUNCTIONS ON MERGE STATEMENTS.

Sorry for the delay. I agree that if you have any leading spaces, you'll need to do one of two things... so far as I'm concerned, the best thing...
--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)

June 20, 2009 at 6:47 pm

#1012914
RE: High volume of transactions definition/measure?

Steve Jones - Editor (6/15/2009)
I think the classification is just to have a frame of reference. It does always change, but it helps to get an idea of scale 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)

June 20, 2009 at 6:29 pm

#1012913
RE: Grouping problem

jcrawf02 (6/18/2009)
. . . and then there are the unfortunate few who keep seeing you lob out these answers, but are still anxiously awaiting 2005 servers. Luckily everyone seems 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)

June 20, 2009 at 6:25 pm

#1012912
RE: Crosstab type report -- Horizontal Summray

Joseph Henry (5/14/2009)
Jeff:
First and foremost, thank you very much for the help you have been providing me. It is helping me to both learn more and have a stronger...
--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)

June 20, 2009 at 6:17 pm

#1012911
RE: Are the posted questions getting worse?

Paul White (6/19/2009)
Jeff Moden (6/19/2009)
Heh... cool... maybe a little head boiling will get him to fix the code windows for IE? 😛
I admire your persistence.
And your optimism!
😛
... and neither...
--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)

June 20, 2009 at 6:02 pm

#1012910
RE: Are the posted questions getting worse?

WayneS (6/20/2009)
Jeff Moden (6/17/2009)
Ummmm.... my rule of thumb is to peel one potato at a time on the quirky update...
Hey Jeff, I remember reading a post where you loaded...
--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)

June 20, 2009 at 5:59 pm

#1012909
RE: Are the posted questions getting worse?

ps (6/20/2009)
Paul White (6/20/2009)
Lynn Pettis (6/20/2009)
If we just give him answers and he ends up in a position that he isn't qualified for do, who's fault is it, ours or...
--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)

June 20, 2009 at 5:39 pm

#1012908
RE: select multiple identity values after insert?

mpacifico (6/19/2009)
Jeff, I can't say that I completely agree. I've run into this problem a number of times now because I have a bunch of data to import that...
--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)

June 20, 2009 at 3:55 pm

#1012904
RE: TempDB mdf file has grown to 11GB

george sibbald (6/19/2009)
tosscrosby (6/19/2009)
sarvesh singh (6/18/2009)
our teste server
I don't even want to know! 😉
we always have a failover pair for those type of servers. 😉
I'll bet that can get...
--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)

June 19, 2009 at 2:01 pm

#1012658
RE: My Approach to Writing for SQLServerCentral

Phil Parkin (6/19/2009)
Steve Jones - Editor (6/19/2009)
"practise" is the English spelling, where David is located. Practice, is the US spelling.
Personally, the more I teach my kids, the more I...
--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)

June 19, 2009 at 2:00 pm

#1012657
RE: TempDB mdf file has grown to 11GB

sarvesh singh (6/19/2009)
the problem was resolved by restarting the sql server.
Heh... nope... just the immediate symptoms. 😉
--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)

June 19, 2009 at 10:10 am

#1012541
RE: Why Object Databases will always be Tomorrow's Technology

Heh... I absolutely love the original version of Hibernate for Java... it keeps writing slow code in HQL and I have a never ending source of code that I can...
--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)

June 19, 2009 at 10:06 am

#1012538
RE: My Approach to Writing for SQLServerCentral

Grant Fritchey (6/19/2009)
Excellent article. Thanks for putting it up. I just wish you had posted it a few years ago. I'm going to print it out now & keep 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)

June 19, 2009 at 10:02 am

#1012536
RE: Are the posted questions getting worse?

Steve Jones - Editor (6/19/2009)
Now THAT put a smile on my face this morning. Apparently I'm not the only one that has bad days. I'll have to bring that up...
--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)

June 19, 2009 at 9:56 am

#1012528
RE: Are the posted questions getting worse?

GilaMonster (6/19/2009)
Jeff Moden (6/18/2009)
Apologies to all... I got the SUM() OVER thing exactly backwards. PARTITION BY is the only part of the OVER clause that can be used. ...
--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)

June 19, 2009 at 9:52 am

#1012524

Viewing 15 posts - 43,336 through 43,350 (of 59,102 total)