Viewing 15 posts - 42,271 through 42,285 (of 59,067 total)
Here folks... give it a try...
DECLARE @SomeVarChar VARCHAR(1000)
SELECT @SomeVarChar = REPLICATE('123456789 ',100)
PRINT '===== Create VARCHAR table ==========================================='
SET...
--Jeff Moden
Change is inevitable... Change for the better is not.
August 16, 2009 at 10:11 pm
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
Change is inevitable... Change for the better is not.
August 16, 2009 at 9:04 pm
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
Change is inevitable... Change for the better is not.
August 16, 2009 at 12:23 pm
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
Change is inevitable... Change for the better is not.
August 15, 2009 at 8:16 pm
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
Change is inevitable... Change for the better is not.
August 15, 2009 at 7:51 pm
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
Change is inevitable... Change for the better is not.
August 15, 2009 at 7:48 pm
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
Change is inevitable... Change for the better is not.
August 15, 2009 at 5:00 pm
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
Change is inevitable... Change for the better is not.
August 15, 2009 at 11:44 am
sayan ghosh (8/15/2009)
--Jeff Moden
Change is inevitable... Change for the better is not.
August 15, 2009 at 10:35 am
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
Change is inevitable... Change for the better is not.
August 15, 2009 at 10:31 am
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
Change is inevitable... Change for the better is not.
August 14, 2009 at 2:28 pm
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
Change is inevitable... Change for the better is not.
August 14, 2009 at 2:14 pm
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
Change is inevitable... Change for the better is not.
August 14, 2009 at 1:40 pm
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
Change is inevitable... Change for the better is not.
August 14, 2009 at 1:30 pm
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
Change is inevitable... Change for the better is not.
August 14, 2009 at 1:17 pm
Viewing 15 posts - 42,271 through 42,285 (of 59,067 total)