Jeff Moden

Forum Replies Created

Viewing 15 posts - 47,911 through 47,925 (of 59,095 total)

RE: Slow SQL Calls

Might not be a mistake on your part... seems to me that, way back when, what you say used to be the truth and they fixed 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)

October 6, 2008 at 9:22 pm

#881415
RE: Cross Tab query

You may also want to try using multiple Selects separated by UNION ALL.
--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)

October 6, 2008 at 9:15 pm

#881414
RE: The Weekly News for Oct 6, 2008 (Database Weekly)

Oh... I almost forgot... I ran Phil's tests without modifying his code. I was so engaged in why he was getting his "reverse" findings, that I actually forgot to...
--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)

October 6, 2008 at 9:12 pm

#881413
RE: The Weekly News for Oct 6, 2008 (Database Weekly)

Thought I'd give a little feedback here... Phil reran his tests on his machine several times... same result... the While loop on a super string beat the tar out 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)

October 6, 2008 at 9:10 pm

#881412
RE: Difference between SQLServer 2005 and SQLServer 7.0 Queries

chileu17 (10/6/2008)
eventhough the table has a primary key? and a non-clustered index?
non-clustered indexes are supposed to be inserted in a specific order right? :ermm: please correct me if I am...
--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)

October 6, 2008 at 8:57 pm

#881407
RE: combining multiple rows into one

zypsy (10/6/2008)
Based on some criteria, I have reduced the number of orders in the dataset
from about 42000 to about 6000.
Then, methinks that something is drastically wrong... you just said (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)

October 6, 2008 at 8:52 pm

#881405
RE: Date range to also compute previous date per no. of days

T-SQL isn't just "Declares"... it also includes all those really handy date functions. 🙂 And, yes... everything is possible...
SELECT CONVERT(CHAR(8),d1.StartDate,1) + ' thru ' + CONVERT(CHAR(8),d1.EndDate,1) ...
--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)

October 6, 2008 at 8:37 pm

#881402
RE: Avoiding Curosr - Yet Another Situation

J (10/6/2008)
Thanks for the help.
Still, the thought process of whoever came up with this one remain baffling. Same as for the guy who figured out that nitroglycerin, an unstable explosive,...
--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)

October 6, 2008 at 6:53 pm

#881397
RE: Updating table based on coalesce reults in where clause?

bobhovious (10/6/2008)
Somewhat embarassing to get caught in typos that increase volumes :w00t:, or quick reads that miss the point being made. But I'll survive.
You never answered the...
--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)

October 6, 2008 at 6:46 pm

#881395
RE: Updating table based on coalesce reults in where clause?

bobhovious (10/6/2008)
Dangit... every time I see a Moden-comment I get befuzzled.
Is that good or bad? 🙂
--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)

October 6, 2008 at 4:03 pm

#881373
RE: Avoiding Curosr - Yet Another Situation

Very well done, Matt. 🙂
J... your "agressive curiosity" is what I call "intellectual curiosity". I believe you won't find yourself alone in that area.
I've not been able to keep...
--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)

October 6, 2008 at 3:51 pm

#881368
RE: combining multiple rows into one

Zypsy absolutely wants to use a spreadsheet because of some functionality that's easily available there. Although I normally oppose denormalized pivots for processing, Zypsy may be correct here 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)

October 6, 2008 at 5:30 am

#881031
RE: Date range to also compute previous date per no. of days

This forum is a bit odd... it sometimes turns left parenthesis into smiley faces. There was one in the test code generator. I've repaired that. Also, to...
--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)

October 6, 2008 at 5:22 am

#881029
RE: Date range to also compute previous date per no. of days

Ok... got it. Since you didn't post the data in an easy to consume format and I just can't bring myself to post untested code, you'll have to put...
--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)

October 5, 2008 at 11:31 pm

#880963
RE: combining multiple rows into one

That's better, but guess what this code means?
SELECT BillDaten, CustCode, COUNT(*) AS ThingsThatNeedPivoting
FROM Sample_Data
GROUP BY BillDaten, CustCode
HAVING COUNT(*) > 1
BillDaten ...
--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)

October 5, 2008 at 10:37 pm

#880958

Viewing 15 posts - 47,911 through 47,925 (of 59,095 total)