Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,966 through 43,980 (of 59,063 total)

RE: Select Values from multiple Rows Into a Single Row

John Bates (4/28/2009)
Jeff,
I will (manually is ok) copy the resultset into an Excel sheet.
Tracking database sizes first day of each month.
Ideally need the sizes (Qty) to be in separate columns.
Thanks,...
--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)

April 29, 2009 at 5:42 pm

#986344
RE: Are the posted questions getting worse?

GilaMonster (4/28/2009)
Lynn Pettis (4/28/2009)
The desert is looking good again...
I might join you this time. For some reason some of the posts over the last few days have been getting 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)

April 29, 2009 at 4:41 pm

#986329
RE: Are the posted questions getting worse?

Grant Fritchey (4/29/2009)
Lynn Pettis (4/29/2009)
GilaMonster (4/29/2009)
Bruce W Cassidy (4/29/2009)
[font="Verdana"]International Star Wars day... "May the 4th be with you."[/font]
*groan*
Hmmm, we were discussing having another Starwars day.....
Now for something totally 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)

April 29, 2009 at 4:19 pm

#986318
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

JohnG (4/29/2009)
Should you wish to parse a string into an Oracle array, there is no real need for the tally table. It will work quite well with a PL/SQL...
--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)

April 29, 2009 at 4:11 pm

#986315
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

Why does it seem that everything is three to five times harder to do in Oracle than it is in SQL Server?
Heh... it's designed that way. ...
--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)

April 29, 2009 at 2:40 pm

#986273
RE: Detect duplicate rows - with a twist

Scott Roberts (4/29/2009)
MSDN states that, by default, "MAX" data types are stored in-row unless they exceed 8,000 bytes, in which case it appears that only the "remaining" data gets stored...
--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)

April 29, 2009 at 2:35 pm

#986269
RE: Detect duplicate rows - with a twist

Scott Roberts (4/29/2009)
I'm interested as well in your "staging table" comments. Would this be only for detecting duplicate records, or would you then create a view over all of 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)

April 29, 2009 at 12:19 pm

#986180
RE: Detect duplicate rows - with a twist

Scott Roberts (4/29/2009)
Sorry about the confusion over mis-matched data sizes for RawData. The RawData column used to be VARCHAR(300) but we encountered a new format that is longer than 300...
--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)

April 29, 2009 at 11:58 am

#986168
RE: SQL Function : Find ‘X’ Business Days in the Future

Bob Hovious (4/29/2009)
But, the same function that works acceptably for doing something one time may crawl if repeated a hundred thousand times. The issue Jeff raised is not whether...
--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)

April 29, 2009 at 11:54 am

#986164
RE: Perform math on string

hayzer (4/29/2009)
So far this is just the second best solution around....
Never allow such garbage in the DATABASE.. 😀
Prevention is better than cure...
Heh... a kindred spirit. I wish more people...
--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)

April 29, 2009 at 8:47 am

#985993
RE: Perform math on string

GSquared (4/29/2009)
Absolutely, but that doesn't actually help the person with the original question, who was handed a database that already had this in it.
Actually, it does... the person now knows...
--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)

April 29, 2009 at 8:45 am

#985991
RE: Perform math on string

Jan Van der Eecken (4/29/2009)
Jeff Moden (4/28/2009)
Sergiy (4/28/2009)
Jeff Moden (4/27/2009)
I don't allow such garbage into my db's to begin with. 😛
I believe this is the method that doesn't suck so...
--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)

April 29, 2009 at 8:42 am

#985986
RE: SQL Function : Find ‘X’ Business Days in the Future

michaelberry67 (4/29/2009)
I think you all my benefit from my function that was published by SQL server magazine:
http://www.sqlmag.com/Articles/ArticleID/97590/97590.html?Ad=1
Do you have any performance stats... say, on 100,000 rows?
--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)

April 29, 2009 at 8:40 am

#985983
RE: Perform math on string

Sergiy (4/28/2009)
Jeff Moden (4/27/2009)
I don't allow such garbage into my db's to begin with. 😛
I believe this is the method that doesn't suck so much.
:hehe:
Heh... I just knew you were...
--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)

April 28, 2009 at 11:18 pm

#985648
RE: Comparison of Dates in SQL

craig.lovegren (4/28/2009)
Jeff Moden (4/28/2009)
Percent of what? Percent of BATCH??? That absolutely cannot be trusted. Only actual cpu usage, duration, reads, and writes should be used to measure...
--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)

April 28, 2009 at 9:06 pm

#985616

Viewing 15 posts - 43,966 through 43,980 (of 59,063 total)