Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,996 through 44,010 (of 59,097 total)

RE: Performance issue with tally solution

Paul White (4/29/2009)
Jeff Moden (4/29/2009)
http://www.sqlservercentral.com/articles/T-SQL/63003/
Thanks Jeff,
I have read that before, and use that approach currently.
When Adam asked for ideas to extend the string-split, this came to mind.
It would be interesting...
--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 7:55 pm

#986367
RE: Special Characters

Ok, here we go... Assuming that you have the company name in a variable and the fact that you're using a version of T-SQL that cannot use functions, here's how...
--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 7:30 pm

#986363
RE: Performance issue with tally solution

Paul White (4/28/2009)
Florian Reischl (4/28/2009)
Hierarchical data to be split? Well. This becomes really freaky... It would require either recursive methods or a much more complex RegEx which also becomes quiet...
--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 6:06 pm

#986347
RE: Special Characters

jim.rasmussen (4/28/2009)
Yes it does. I have researched this, but can't seem to make it work correctly. Any thoughts?
Thanks
Jim
Sorry, Jim... I had almost 900 emails in my inbox since I posted...
--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:58 pm

#986346
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

Viewing 15 posts - 43,996 through 44,010 (of 59,097 total)