Jeff Moden

Forum Replies Created

Viewing 15 posts - 10,471 through 10,485 (of 59,095 total)

RE: Sql injection

andycadley - Sunday, December 2, 2018 9:48 AM
Using parameterised queries can avoid pretty much every possible case of this (except maybe second-order...
--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)

December 2, 2018 at 10:30 am

#2015240
RE: Replace trigger with some other approach?

I don't recall looking at this one. I can tell you that I don't have the time to look at every post.
If I had looked at it, keep...
--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)

December 2, 2018 at 9:47 am

#2015236
RE: Request code review for UDF: ContainsControlChar and CleanString

Eirikur Eiriksson - Saturday, December 1, 2018 12:34 PM
Jeff Moden - Friday, November 30, 2018 8:15 AM
--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)

December 1, 2018 at 3:08 pm

#2015219
RE: Need index suggestion

Heh... ok. I'm confused. Here's the original query posted by the OP.
SELECT SalesDate, SalesPersonID FROM dbo.Sales WHERE ProductID='PD1’ Order by productname;
Can someone please...
--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)

November 30, 2018 at 8:59 pm

#2015194
RE: Issues with filling in the blanks from a calendar table.

I might simply be missing it but do you have an example of what you actually want to save to a table using the given data?
--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)

November 30, 2018 at 6:49 pm

#2015191
RE: Sql injection

Matt Miller (4) - Friday, November 30, 2018 5:21 PM
Matt Miller (4) - Friday, November 30, 2018...
--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)

November 30, 2018 at 6:41 pm

#2015190
RE: Sql injection

autoexcrement - Friday, November 30, 2018 2:37 PM
I'd love to see an example too. But it seems the issue is somewhat complicated...
--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)

November 30, 2018 at 5:46 pm

#2015188
RE: Database Performance slowness issue

santosh.mane - Friday, November 30, 2018 7:05 AM
muthukkumaran Kaliyamoorthy - Friday, November 30, 2018 4:58 AM
--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)

November 30, 2018 at 4:57 pm

#2015184
RE: Sql injection

Jonathan AC Roberts - Friday, November 30, 2018 6:52 AM
sandro.venturoni - Friday, November 30, 2018 2:40 AM
--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)

November 30, 2018 at 8:40 am

#2015133
RE: Need index suggestion

Jonathan AC Roberts - Friday, November 30, 2018 8:21 AM
Jeff Moden - Friday, November 30, 2018 8:02...
--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)

November 30, 2018 at 8:30 am

#2015131
RE: Request code review for UDF: ContainsControlChar and CleanString

I'll take a closer look over the weekend (as I'm sure some of the heavy hitters on this site also will) but the fact that these are scalar functions and...
--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)

November 30, 2018 at 8:15 am

#2015128
RE: Need index suggestion

Jonathan AC Roberts - Thursday, November 29, 2018 7:51 AM
samantha.sqldba - Thursday, November 29, 2018 7:08 AM
--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)

November 30, 2018 at 8:02 am

#2015124
RE: Need index suggestion

John Mitchell-245523 - Thursday, November 29, 2018 7:16 AM
Sam
Looks like you need to do a bit of normalising first - you shouldn'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)

November 30, 2018 at 8:00 am

#2015122
RE: Small negative numbers

Solomon Rutzky - Wednesday, November 28, 2018 2:14 PM
It's mostly a matter of scale. When dealing with up to a few...
--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)

November 29, 2018 at 9:50 pm

#2015045
RE: Hierarchies on Steroids #1: Convert an Adjacency List to Nested Sets

Y.B. - Thursday, November 29, 2018 11:44 AM
Just seeing this post pop up again reminded me I needed to thank you Jeff...
--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)

November 29, 2018 at 9:27 pm

#2015043

Viewing 15 posts - 10,471 through 10,485 (of 59,095 total)