Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,571 through 39,585 (of 59,072 total)

RE: Fast random row selector

ssc-574207 (2/25/2010)
Thanks. We had tried ORDER BY NEWID() and as Ron suggested it was definitely slower.
TABLESAMPLE didn't work because we need a sample of joined rows and you can...
--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 27, 2010 at 9:56 am

#1126109
RE: Calculating interest query

Paul White (2/27/2010)
Chris,
Turns out all that is needed to get rid of the index spool is to define the clustered index as UNIQUE. Given that information, a better plan...
--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 27, 2010 at 9:13 am

#1126103
RE: Calculating interest query

Paul White (2/27/2010)
This is a method called 'set-based iteration' by MVP Hugo Kornelis, which was first brought to my attention here in a discussion of one of Jeff's fine articles.
Heh......
--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 27, 2010 at 9:08 am

#1126101
RE: Avoid dynamic SQL

Kingston Dhasian (2/26/2010)
Paul White (2/26/2010)
--------------------------------------------------------------------------------
If you have a pain in your finger, chopping your hand off is not the solution.
In fairness, it is *a* solution, just probably not optimal...
--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 27, 2010 at 12:03 am

#1126015
RE: Are the posted questions getting worse?

Paul White (2/26/2010)
Jeff,
Did you really just post:
The actions to take to counter intrusions should always be taken before the attempt at penetration and I'm careful to take those actions.
...? ...
--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 26, 2010 at 11:57 pm

#1126014
RE: Are the posted questions getting worse?

Paul White (2/26/2010)
CirquedeSQLeil (2/26/2010)
Sad when they just won't relent - just keep pushing it. Not good.
I posted it there, and I'm posting it here:
http://meta.wikimedia.org/wiki/Don't_be_a_dick
Mr Corgi needs less of whatever...
--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 26, 2010 at 11:54 pm

#1126011
RE: Avoid dynamic SQL

Welsh Corgi (2/26/2010)
Jeff,
Have yo ever been a victim of SQL Injection?
If so what hits did you take?
What actions did you take to counter this intrusion and how 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)

February 26, 2010 at 11:40 pm

#1126008
RE: Are the posted questions getting worse?

Man... now I know how Gail feels. :blink:
--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 26, 2010 at 11:11 pm

#1125993
RE: Avoid dynamic SQL

Welsh Corgi (2/26/2010)
Thank you Jeff. I read your link concerning the SQL Injections.
However there is a lot more to consider that what is addressed in this article.
You are...
--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 26, 2010 at 10:56 pm

#1125985
RE: Remove non printable characters

Ramesh Saive (2/8/2010)
Jeff Moden (2/6/2010)
...... I should have qualified my statement. Instead of saying...
"I believe you'll find it's a wee bit more difficult to do than just using...
--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 26, 2010 at 10:50 pm

#1125981
RE: Remove non printable characters

Paul White (2/26/2010)
Hey Jeff,
Scalar T-SQL functions?! WHILE loops? I am genuinely shocked! :w00t:
Me too! I guess I've cut way too far back on the coffee and pork...
--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 26, 2010 at 10:46 pm

#1125977
RE: Are the posted questions getting worse?

I guess I'd get into trouble if I recommended that someone started Lithium treatment, huh?
http://www.sqlservercentral.com/Forums/Topic873721-145-1.aspx
--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 26, 2010 at 10:35 pm

#1125975
RE: Avoid dynamic SQL

Heh... I tried. Whatever WC. Have a good one.
--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 26, 2010 at 10:35 pm

#1125973
RE: Avoid dynamic SQL

Welsh Corgi (2/26/2010)
I would respectfully request that the members of this forum be professional.
You should conduct yourself on a professional manner.
If a forum manner pots something 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)

February 26, 2010 at 10:21 pm

#1125969
RE: Avoid dynamic SQL

Welsh Corgi (2/26/2010)
OK, Jeff thank you for your criticism.
I did not intend to make anyone feel uncomfortable but as much as you add to this forum you make...
--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 26, 2010 at 10:18 pm

#1125967

Viewing 15 posts - 39,571 through 39,585 (of 59,072 total)