Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,271 through 42,285 (of 59,067 total)

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
RE: differiniate quotes as data vs quotes as column identifier

Is the "wholerow" text stored as VARCHAR(8000) or VARCHAR(MAX)? If it's VARCHAR(MAX), does it need to be? Since VARCHAR(MAX) is inherently "out of row" (or whatever you want...
--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 14, 2009 at 2:28 pm

#1039706
RE: Syntax for altering all databases?

Bob's method eliminates the use of a cursor. If you need to "productionalize" something like that, we can do a little XML concatenation into a variable using his good...
--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 14, 2009 at 2:14 pm

#1039697
RE: How to delete huge amount of data

gah (8/14/2009)
Plase excuse my ignorance, but how much is a "crore"?
does one "crore" represent ten million (10,000,000) ?
gah
From WikiPedia.com...
A crore (Hindi: ?????) (often abbreviated cr) is a unit 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)

August 14, 2009 at 1:40 pm

#1039669
RE: Syntax for altering all databases?

For quick and dirty stuff like that, GOOGLE the undocumented sp_MSForEachDB extended stored procedure. It's got a nasty cursor in it but it is convenient for this type 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)

August 14, 2009 at 1:30 pm

#1039658
RE: differiniate quotes as data vs quotes as column identifier

Heh... yeah, I forgot about that. Add TOP 2000000000 to the SELECT in the CTE. Don't use TOP 100%... although I haven't had the time to verify 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 14, 2009 at 1:17 pm

#1039651

Viewing 15 posts - 42,271 through 42,285 (of 59,067 total)