Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,691 through 45,705 (of 59,095 total)

RE: Are the posted answers getting worse?

BWAA-HAA!! I'd like to see a thread on nominations as to who can fire the best pork chops and it can't be yourself! Here's a recent post that would...
--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)

January 21, 2009 at 7:50 pm

#930850
RE: Correct use of @variables and uniqueidentifiers

I have to ask, why do you have multiple GUID's in a single column?
--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)

January 21, 2009 at 7:47 pm

#930848
RE: Are the posted answers getting worse?

RBarryYoung (1/21/2009)
Man, what a bonehead!
And all that time.... I thought it was a helmet. 😉
--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)

January 21, 2009 at 7:43 pm

#930846
RE: backup failure

ps (1/20/2009)
:w00t: Is there a rationale behind this weird behaviour?
Heh... WHICH wierd behaviour? :hehe:
--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)

January 21, 2009 at 7:18 pm

#930842
RE: 16 digit unique number

colin Leversuch-Roberts (1/21/2009)
I knew you'd be a voice of reason Jeff! I truly don't know any way you can do this in T-SQL and I'm not sure you could do...
--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)

January 21, 2009 at 7:14 pm

#930839
RE: Questions on looping and grouping data

You could try the old COMPUTE and COMPUTE BY clauses... don't know if they have the same limits... but, be advised, the totals are NOT returned in the same result...
--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)

January 21, 2009 at 7:10 pm

#930838
RE: Questions on looping and grouping data

You're grouping by more than 10 columns? Sorry, that's not what I saw in the original post and haven't read the other chunk of code you posted.
--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)

January 21, 2009 at 7:06 pm

#930834
RE: Surface Possibilities

Send huge amounts of money or the winning Mega-Bucks lottery ticket and I'll start writing my memoirs! 😀
--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)

January 21, 2009 at 6:59 pm

#930832
RE: Are the posted questions getting worse?

RBarryYoung (1/21/2009)
David Webb (1/21/2009)
Give a man a fish and you feed him for a day. Teach a man to fish and you feed him for a lifetime.
Yes, and HIT...
--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)

January 21, 2009 at 6:55 pm

#930831
RE: Are the posted questions getting worse?

David Webb (1/21/2009)
Give a man a fish and you feed him for a day. Teach a man to fish and you feed him for a lifetime. In 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)

January 21, 2009 at 6:53 pm

#930830
RE: Disable and enable trigger

amartha_dutta (1/21/2009)
To disable / enable selective triggers...
ALTER TABLE tableName DISABLE TRIGGER triggername
ALTER TABLE tableName ENABLE TRIGGER triggername
To disable / enable all triggers...
ALTER TABLE tableName DISABLE TRIGGER ALL
ALTER TABLE tableName ENABLE...
--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)

January 21, 2009 at 6:44 pm

#930827
RE: VM... Setting up new "box"

Ok... still not sure what you mean, so I'll come right out and ask... Do you think I'm part of the problem on this one?
--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)

January 21, 2009 at 6:42 pm

#930826
RE: Why do people need to do this?

RBarryYoung (1/20/2009)
Heh, maybe I shouldn't post after midnight. But sure, use it if it helps. 😛
Heh... gotta love it when you take the helmet off... right about midnight...
--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)

January 21, 2009 at 6:39 pm

#930825
RE: Why do people need to do this?

Garadin (1/20/2009)
Michael Valentine Jones (1/20/2009)
In the end, does the reason why really matter?
We had a meeting where we objected to a project as complete waste time and money, and were...
--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)

January 21, 2009 at 6:37 pm

#930824
RE: Why do people need to do this?

smunson (1/21/2009)
Jeff,
Thanks for the validation. Barry did kind of get back at what I was saying - there's really only one reason for this kind of problem -...
--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)

January 21, 2009 at 6:36 pm

#930823

Viewing 15 posts - 45,691 through 45,705 (of 59,095 total)