Jeff Moden

Forum Replies Created

Viewing 15 posts - 45,931 through 45,945 (of 59,101 total)

RE: Best performance Row by row loop (SQL2K)

agh100 (1/15/2009)
Hi,
What I need to do is:
Find out which specific rows and columns that contains ascii values below 32, and log it either in a txt file or another db.
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)

January 15, 2009 at 8:02 am

#927337
RE: Best performance Row by row loop (SQL2K)

GSquared (1/15/2009)
If you actually have to do row-by-row, use a cursor for it. It's what they're built for, and they're good at it. While loops for row-by-row aren't...
--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)

January 15, 2009 at 8:00 am

#927335
RE: Common Mistakes in T-SQL

GilaMonster (1/15/2009)
Agreed. I'm in the middle of a wonderful one now.
That's just nasty... went through that in my last company. Some high level genius at the company bought a...
--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)

January 15, 2009 at 7:10 am

#927265
RE: Common Mistakes in T-SQL

That's another good one. And, I've never seen it where they need to return an out of scope identity produced by @@IDENTITY... anyone ever actually do that? What...
--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)

January 15, 2009 at 6:14 am

#927212
RE: cross tab

But, aren't you executing the column merge code once for each "employee"?
And, if you're happy with the speed, then that's what matters. 😀
--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)

January 15, 2009 at 6:10 am

#927210
RE: Are the posted questions getting worse?

DavidB (1/15/2009)
See what happens when you leave people up in cold weather for too long. And you thought it was unsafe to go in the rural spots down south. :w00t:
BWAA-HAA!!...
--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)

January 15, 2009 at 6:06 am

#927207
RE: Are the posted questions getting worse?

Michael Earl (1/15/2009)
After extensive testing, Aqua Net hair spray ended up being better than any other propellant we could find.
Any build up on the walls over time?
--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)

January 15, 2009 at 6:02 am

#927206
RE: Are the posted questions getting worse?

Chris Morris (1/15/2009)
Top work! What do you use as propellant? Don't tell me...when you're not clearing tables you collect the stuff 😛
Ronson Lighter fluid... it's "ashless".
--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)

January 15, 2009 at 6:00 am

#927203
RE: Are the posted questions getting worse?

RBarryYoung (1/14/2009)
Don't bother, Jeff. I found a photo of you with the Recoiless Pork Chop Launcher from your old delivery job:
Heh... man, you don't know how close that is......
--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)

January 14, 2009 at 11:11 pm

#927078
RE: Is there a Bug with the Replace() Function in SQL Server 2005

Lynn Pettis (1/14/2009)
Different subject, have you had a chance to test my code yourself? After my last test, I feel much better.
No... and today pretty much stunk for doing...
--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)

January 14, 2009 at 10:23 pm

#927066
RE: Is there a Bug with the Replace() Function in SQL Server 2005

Heh... beat you to it. See you tomorrow night.
--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)

January 14, 2009 at 10:18 pm

#927065
RE: Are the posted questions getting worse?

LOL!!! Now, that just figures... :hehe:
--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)

January 14, 2009 at 10:12 pm

#927062
RE: Is there a Bug with the Replace() Function in SQL Server 2005

Heh... it actually doesn't really matter at all... here's why...
SELECT TOP 1000
REPLACE(REPLICATE('=',t.N)+'9','9','88') AS R,
...
--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)

January 14, 2009 at 10:08 pm

#927061
RE: Is there a Bug with the Replace() Function in SQL Server 2005

Test it... you'll find out differently... no warning.
Same holds true for the following...
SELECT REPLACE(REPLICATE('=',7999)+'9','9','88')
Truncation with no warning.
So, there is truncation with no warning for both. To me, that...
--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)

January 14, 2009 at 9:53 pm

#927057
RE: Is there a Bug with the Replace() Function in SQL Server 2005

Sorry... getting a bit tired and, like you said, shouldn't have posted "the short answer". 😀
What happens with the following in SQL Server 2000? 2005?
SELECT STUFF(REPLICATE('=',8000),1,0,'=')
--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)

January 14, 2009 at 9:35 pm

#927052

Viewing 15 posts - 45,931 through 45,945 (of 59,101 total)