Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,241 through 36,255 (of 59,102 total)

RE: got a parameter sniffing example/demo script?

GilaMonster (10/27/2010)
Lowell (10/27/2010)
I'd said previously that my theory is when parameter sniffing occurs, i think the saved execution plan is used to get the data on a row by row...
--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)

October 28, 2010 at 3:00 am

#1243399
RE: Searching on Multiple Tables

InfiniteError (10/28/2010)
Hi,
I know that many sql developer here can give me clarification on this matter.
What I want to know is that,
For example I want to search these strings(ex. 'Asanti','Goodyear','Cadillac'), 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)

October 28, 2010 at 2:54 am

#1243393
RE: Parent/Child relationship

Chrissy321 (10/27/2010)
Thnaks All. I was able to reach a suitable solution using the CASE WHEN EXISTS syntax!
That's cool... can you post your final code, 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)

October 28, 2010 at 2:51 am

#1243392
RE: Parent/Child relationship

CELKO (10/27/2010)
CREATE VIEW MarkedChildren (parent_id, child_id, [font="Arial Black"]silly_flag[/font])
You just can't resist, can ya? 😉
--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)

October 28, 2010 at 2:50 am

#1243391
RE: Ordering by month, show name

Task complete. Submitted article via "Write For Us".
--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)

October 28, 2010 at 12:57 am

#1243361
RE: Are the posted questions getting worse?

Jeff Moden (10/28/2010)
Ok... first one is done. I liked Paul's idea of "Phil McCracken" as the author. Please see attached just for a preview. Steve, I'll post...
--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)

October 28, 2010 at 12:53 am

#1243360
RE: Are the posted questions getting worse?

Ok... first one is done. I liked Paul's idea of "Phil McCracken" as the author. Please see attached just for a preview. Steve, I'll post it in...
--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)

October 28, 2010 at 12:05 am

#1243348
RE: Are the posted questions getting worse?

Paul White NZ (10/27/2010)
...the author should definitely be shown as Phil McCracken 😎
Now THAT's entertainment! 😀
--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)

October 27, 2010 at 10:17 pm

#1243317
RE: Are the posted questions getting worse?

Here's what I quickly came up with to act as both the introduction to the article and the "teaser" for the news letter for the "Ordering by Months" article...
[font="Arial Black"]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)

October 27, 2010 at 10:11 pm

#1243316
RE: Are the posted questions getting worse?

Craig Farrell (10/27/2010)
Steve Jones - SSC Editor (10/27/2010)
pin a post in that forum? Or others? Don't want to pin in every forum.
Shame you can't have those two links just be...
--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)

October 27, 2010 at 9:51 pm

#1243305
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (10/27/2010)
Jeff Moden (10/27/2010)
I'll be happy to do the "Ordering months by number" thing. Like Lynn says, though, it would really be helpful if we...
--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)

October 27, 2010 at 9:50 pm

#1243304
RE: Ordering by month, show name

I'll take this one on.
--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)

October 27, 2010 at 9:35 pm

#1243298
RE: Are the posted questions getting worse?

Steve Jones - SSC Editor (10/27/2010)
OK, sign up for articles. Please just pick one, then another when you finish.
If you have ideas, feel free to post them, but try 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)

October 27, 2010 at 9:34 pm

#1243297
RE: In Line Subquery versus Join query

am-244616 (10/27/2010)
Guys,
I am trying to figure out the advantages and disadvantages in terms of performance for in line sub query versus join based query.
In the below query the EMPLOYEE_TYP 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)

October 27, 2010 at 8:51 pm

#1243285
RE: Get the Current Date

CELKO (10/27/2010)
[In ANSI the syntax would be more natural since it uses plus and minus and the ability to use year-month-day and hour-minute-second intervals.
.
.
.)
Likewise, a mixed interval
...
--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)

October 27, 2010 at 8:41 pm

#1243281

Viewing 15 posts - 36,241 through 36,255 (of 59,102 total)