Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,301 through 42,315 (of 59,102 total)

RE: Are the posted questions getting worse?

GilaMonster (8/17/2009)
Jeff Moden (8/17/2009)
Heh... yeah, but being the responsible person you are, I'll bet you went back and fixed it as soon as you realized the mistake.
He went...
--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)

August 17, 2009 at 9:23 am

#1040270
RE: Are the posted questions getting worse?

GSquared (8/17/2009)
Heh... if the eyes reveal the soul, the blog reveals the mind.
I'm nearly blind (can see about 6 inches without glasses), and my blog is empty ... the implications...
--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)

August 17, 2009 at 9:21 am

#1040268
RE: How to trim the decimal places?

Thanks for the feedback, Tatoba.
--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)

August 17, 2009 at 8:59 am

#1040253
RE: Are the posted questions getting worse?

Grant Fritchey (8/17/2009)
Jeff Moden (8/15/2009)
GilaMonster (8/15/2009)
Jeff Moden (8/15/2009)
Yeah... I love people's blogs... 😛
Ok, now I'm worried....
Heh... please don't be. Your blogs are the epitome of what every DBA 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)

August 17, 2009 at 8:40 am

#1040233
RE: Table variables vs. temp tables, and should I use subqueries to minimize # of updates in these?

OPTION F... Single "Quirky Update"
Problem: Post to too abstract to help.
--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)

August 16, 2009 at 10:20 pm

#1040013
RE: varchar(max) or varchar(some large number)?

Here folks... give it a try...
DECLARE @SomeVarChar VARCHAR(1000)
SELECT @SomeVarChar = REPLICATE('123456789 ',100)

PRINT '===== Create VARCHAR table ==========================================='
SET...
--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)

August 16, 2009 at 10:11 pm

#1040009
RE: varchar(max) or varchar(some large number)?

I do know that there is a rather significant difference in performance between VARCHAR(somenumber) AND VARCHAR(MAX) even if you never get past 8k with the VARCHAR(MAX) for things like Tally...
--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)

August 16, 2009 at 9:04 pm

#1039997
RE: Are the posted questions getting worse?

Lynn Pettis (8/15/2009)
Jeff Moden (8/15/2009)
Lynn Pettis (8/15/2009)
GilaMonster (8/15/2009)
Lynn Pettis (8/15/2009)
You'd think someone with the alphabet soup following his name would know better.
Yes, you would.... Especially the one that reads 'MCT'
I've...
--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)

August 16, 2009 at 12:23 pm

#1039974
RE: Are the posted questions getting worse?

D.Oc (8/15/2009)
Jeff, it appears you are very popular among article stealers 😛
Ugh! So it would seem. BWAA-HAAA!!! I've gotta look at the bright side though... apparently they...
--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)

August 15, 2009 at 8:16 pm

#1039904
RE: Are the posted questions getting worse?

Lynn Pettis (8/15/2009)
GilaMonster (8/15/2009)
Lynn Pettis (8/15/2009)
You'd think someone with the alphabet soup following his name would know better.
Yes, you would.... Especially the one that reads 'MCT'
I've corrected him elsewhere also...
--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)

August 15, 2009 at 7:51 pm

#1039902
RE: Are the posted questions getting worse?

GilaMonster (8/15/2009)
Jeff Moden (8/15/2009)
Yeah... I love people's blogs... 😛
Ok, now I'm worried....
Heh... please don't be. Your blogs are the epitome of what every DBA and database consultant should strive...
--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)

August 15, 2009 at 7:48 pm

#1039901
RE: Did Oracle buy MySQL by accident?

I didn't know Oracle bought MySQL. Thanks for the info.
Heh... reminds me of the days when IBM bought Lotus. Lotus 1-2-3 was HUGE before IBM bought 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)

August 15, 2009 at 5:00 pm

#1039897
RE: Are the posted questions getting worse?

Steve Jones - Editor (8/15/2009)
I sometimes think people are trying hard to build a reputation by answering, and don't want to read. They want to just throw something out there.
Man,...
--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)

August 15, 2009 at 11:44 am

#1039853
RE: Transfering content of a string variable to a file in a SP

sayan ghosh (8/15/2009)
Thanks to everyone for their inputs. I came to know that Varchar(8000) is the max I could pass from an SP to SSIS, also that's the max Xp_CmdShell...
--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)

August 15, 2009 at 10:35 am

#1039849
RE: Are the posted questions getting worse?

GilaMonster (8/14/2009)
BTW... how did you know the tower number?
See attachment. That's the connection software that the modem uses (bloody irritating that it's needed)
Cool... thanks. BWAA-HAAA!!! I was worried...
--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)

August 15, 2009 at 10:31 am

#1039848

Viewing 15 posts - 42,301 through 42,315 (of 59,102 total)