Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,921 through 43,935 (of 59,101 total)

RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

JohnG (5/4/2009)
peter (5/4/2009)
True, from an ADO client application. However, It doesn't work from T-SQL. I.e., You cannot consume a result set returned by a stored procedure within T-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)

May 4, 2009 at 11:27 am

#988234
RE: There Must Be 15 Ways To Lose Your Cursors… Part 2: Just Put It in a S

Heh... on the other hand, if the worst cursor someone writes is to pass individual records to an email routine, then there also wouldn't be a need for this series...
--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)

May 4, 2009 at 11:24 am

#988232
RE: The Next Frontier of Performance Troubleshooting

Indianrock (5/4/2009)
But again, the ones that report on stored procedures do almost nothing in our environment since procs are hardly used.
That's why I start performance monitoring at the "Batch Completion"...
--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)

May 4, 2009 at 11:18 am

#988226
RE: Unsubscribe from Topic

Steve Jones - Editor (5/4/2009)
Hint taken, it's on the list.
Thanks, Steve. Just an FYI... I've upgraded to the other "sin"... IE8. No changes to report. Everything previously...
--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)

May 4, 2009 at 11:14 am

#988221
RE: Calculating Work Days

Lynn Pettis (2/19/2009)
I don't think our PeopleSoft Admin has gotten around to this, so I thought I'd drop a line. She found your routine quite elegant and saved her...
--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)

May 4, 2009 at 11:11 am

#988219
RE: Calculating Work Days

James A. Lawrence (5/4/2009)
Just tried this out....good job!
Or in SoCal parlance: "Dude, you rock!":cool:
Great to hear, James. Thanks for taking the time to post a reply. 🙂
--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)

May 4, 2009 at 11:10 am

#988217
RE: The "Numbers" or "Tally" Table: What it is and how it replaces a loop.

I missed that, Peter. Thanks for pointing it out.
I agree... there is no need to fill a temp table in SQL Server to read a result set. Of...
--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)

May 4, 2009 at 5:34 am

#988038
RE: Filtered index with IS NULL predicate

In that case, I'd recommend that you remove the index hint and add the proper index as a covering index instead of what you currently have as IX_0. By...
--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)

May 3, 2009 at 8:43 pm

#987904
RE: Rolling up hierarchical costs

Vaughan,
I noticed zero replies on your post... did you eventually get this or do you still need help?
--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)

May 3, 2009 at 6:55 pm

#987892
RE: Need help writing query

WayneS (4/30/2009)
patrick ryan (4/30/2009)
I need help writing a query. I attached an excel file with sample data.
Hi Patrick,
It really helps all of the volunteers that help out on this...
--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)

May 3, 2009 at 6:18 pm

#987890
RE: Updating records through query

nahid.mansuri (4/30/2009)
I have a update query as below.
Update equipment
set name = 'A'
where name = 'B'
And in the Update trigger, i will try to update some other columns too.
Like Address,...
--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)

May 3, 2009 at 6:14 pm

#987888
RE: Read from Text file

steveb (5/1/2009)
I did something like this recently and tried a few approaches but eded up using LogParser, its a free tool from microsoft that reads log files and can output...
--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)

May 3, 2009 at 6:11 pm

#987887
RE: SQL 2005 Selecting data Into a #TempTable then query it

Warren Peace (5/1/2009)
That was it.
Thanks, I got it going!
Could you post the code that solved the problem, please? Thanks.
--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)

May 3, 2009 at 6:06 pm

#987885
RE: There Must Be 15 Ways To Lose Your Cursors… Part 2: Just Put It in a S

Samuel Vella (5/1/2009)
Cross Apply usually results in hidden RBAR so no real benefit over an efficient cursor based procedure
Heh... as you said, "usually". We've recently done some experiments 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)

May 3, 2009 at 4:27 pm

#987873
RE: Are the posted questions getting worse?

Florian Reischl (5/3/2009)
Sorry for disturbing the silence of The Thread but I have to get this off my chest...
I HATE EXCEL!! I'm about to finish my first article and want...
--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)

May 3, 2009 at 2:19 pm

#987850

Viewing 15 posts - 43,921 through 43,935 (of 59,101 total)