Jeff Moden

Forum Replies Created

Viewing 15 posts - 35,161 through 35,175 (of 59,099 total)

RE: Display More Than 8000 Characters (SQL Spackle)

JJ B (2/3/2011)
JJ B. If you're not currently using a loop or the method in the article, what are you using?
I'll tell ya, but you have to be kind (not...
--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)

February 4, 2011 at 6:54 am

#1282427
RE: Formatting Dates with 3 Character Months (SQL Spackle)

UMG Developer (2/3/2011)
Jeff Moden (2/2/2011)
BWAA-HAA!!! Thanks for the great feedback, David. And, just to make sure, I have to tell you that that version of the Tally table...
--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)

February 4, 2011 at 6:47 am

#1282420
RE: Need the Price with the Latest Date

Craig Farrell (2/3/2011)
Hm, you appear to have hit on something here... especially depending on the indexing.
Using this new benchmarking code:
Wow! Lots'o code! What conclusion do you draw from...
--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)

February 4, 2011 at 6:38 am

#1282408
RE: Need the Price with the Latest Date

drew.allen (2/1/2011)
Jeff Moden (2/1/2011)
drew.allen (1/31/2011)
Craig Farrell (1/31/2011)
After having done some other tests, this method seems to be the quickest, especially if you have a solid index on Item/ChangePriceDate
My tests indicate...
--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)

February 4, 2011 at 6:35 am

#1282406
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (2/3/2011)
I have removed the "questionhacker" thread and account. It might not stop him from coming back, but I also sent an email, so we'll see....
--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)

February 4, 2011 at 6:23 am

#1282395
RE: Are the posted questions getting worse?

Lynn Pettis (2/3/2011)
Lynn Pettis (2/2/2011)
Amazing it is how arrogant some may be.
And then to post here as well?
EDIT: For those interested, the links above are broken.
Probably missing rather than broken......
--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)

February 4, 2011 at 6:17 am

#1282394
RE: Display More Than 8000 Characters (SQL Spackle)

timothyawiseman (2/1/2011)
I have run into this problem off and on, and once even wrote a solution to it ( http://www.sqlservercentral.com/scripts/Print/63240/%5B/url%5D ). After struggling with it myself a few times,...
--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)

February 3, 2011 at 7:07 am

#1281891
RE: Display More Than 8000 Characters (SQL Spackle)

Roy Ernest (1/31/2011)
Hi Jeff, Great article as usual. 🙂
Hi Roy! Thanks for the read and the comment. Always a pleasure.
--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)

February 3, 2011 at 6:59 am

#1281887
RE: ForEach Loop and an ADO Recordset

Thanks for the feedback, Craig. Yep... not that it matters but I agree with that justification. Please understand that, considering the source, I just had to ask. ...
--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)

February 3, 2011 at 6:55 am

#1281885
RE: Are the posted questions getting worse?

GilaMonster (2/3/2011)
Tom Brown (2/3/2011)
[There is a "Report" button I always wondered why then when phrases the like of which this pet troll uses appear directed at our well known...
--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)

February 3, 2011 at 6:37 am

#1281873
RE: Solving the "Running Total" & "Ordinal Rank" Problems (Rewritten)

mmarovic (2/2/2011)
Hello Jeff & Co. Really great article and awesome discussion. I wrote an article about the topic five years ago, but my investigation lacked depth of the Jeff's article...
--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)

February 3, 2011 at 6:32 am

#1281870
RE: UPDATE using a self-join

Brandie Tarvin (2/1/2011)
GSquared (2/1/2011)
Stefan Krzywicki (2/1/2011)
Brandie Tarvin (2/1/2011)
CELKO (1/31/2011)
Successful projects start on lesser SQLs (even ACCESS ) then have to move to DB2, Oracle, Teradata or whatever.
Including Access? What other...
--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)

February 3, 2011 at 12:35 am

#1281744
RE: UPDATE using a self-join

CELKO (1/31/2011)
I do believe in portable SQL; I earn a living from it . Most ports are from release(n) to release(n+1) of the same SQL product.
That, good sir, has been...
--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)

February 3, 2011 at 12:23 am

#1281740
RE: scalable hardware solution for 10TB now to 100TB in 3 years

mlbauer (1/25/2011)
Hi,
good question. The short answer is: We know our data will grow. We want to do our current tasks in the future, so we want 10x performance and capacity....
--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)

February 3, 2011 at 12:06 am

#1281737
RE: SQL statement problem

GSquared (2/2/2011)
Jeff Moden (2/1/2011)
GSquared (2/1/2011)
The first step is to build a Select statement that will get all the ones you want to exclude directly or indirectly.
select *
from MyTable
where ip =...
--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)

February 2, 2011 at 11:56 pm

#1281736

Viewing 15 posts - 35,161 through 35,175 (of 59,099 total)