Jeff Moden

Forum Replies Created

Viewing 15 posts - 39,601 through 39,615 (of 59,098 total)

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
RE: Avoid dynamic SQL

The other thing to consider is that not all dynamic SQL receives paramaters from the outside world. Such dynamic SQL needs virtually no protection.
As a side bar... let's see...
--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:11 pm

#1125964
RE: Avoid dynamic SQL

RBarryYoung (2/26/2010)
Jeff Moden (2/26/2010)
Welsh Corgi (2/26/2010)
I agree with the distinguished Forum Members with respect to the use of Dynamic SQL.
There are many reasons to avoid this. If you...
--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 9:53 pm

#1125958
RE: Avoid dynamic SQL

Welsh Corgi (2/26/2010)
OK, Jeff & Barry you point is
well taken. I appreciate critisism but when you present a problem you should provide a solution...
I'm good at 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 9:51 pm

#1125956
RE: Slow performant select query, yet apparently simple.

The problem is that you're trying to return too much data at the very beginning. The only thing you should initially be concerned with for paging is getting 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)

February 26, 2010 at 9:45 pm

#1125950

Viewing 15 posts - 39,601 through 39,615 (of 59,098 total)