Jeff Moden

Forum Replies Created

Viewing 15 posts - 44,131 through 44,145 (of 59,101 total)

RE: Performance issue with tally solution

By the way... thanks, Phil. I didn't know decompilers had come some far. I thought I was going to be looking at raw machine language and I haven'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)

April 19, 2009 at 9:51 am

#980353
RE: Performance issue with tally solution

Florian Reischl (4/18/2009)
The reflector is a really great tool to look into any .Net assembly since it is not encrypted. You can easily browse through all classes, methods and properties...
--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)

April 18, 2009 at 8:20 pm

#980299
RE: Performance issue with tally solution

Florian Reischl (4/18/2009)
(more than 7 years ago)
So you are already an old hand
Oddly enough, so is the rest of me. 😉
--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)

April 18, 2009 at 7:49 pm

#980297
RE: Are the posted questions getting worse?

Florian Reischl (4/18/2009)
I have a short question depending on the article I intend to write (CLR solutions to split strings).
What do you like more C# or VB.Net? It doesn't matter...
--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)

April 18, 2009 at 4:08 pm

#980272
RE: Are the posted questions getting worse?

GilaMonster (4/18/2009)
Anyone got SQL 2000? More specifically Query Analyser?
If so, can you please get me a screen shot of the following.
Run the following:
SET STATISTICS PROFILE ON
GO
SELECT * FROM sysobjects
There will...
--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)

April 18, 2009 at 3:43 pm

#980268
RE: Performance issue with tally solution

Florian Reischl (4/18/2009)
I agree with Jeff. Sure, it is simple to have a look into the assembly with .Net Reflector. But since you are no C#/VB.Net/... developer it might look...
--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)

April 18, 2009 at 3:21 pm

#980260
RE: Performance issue with tally solution

Phil Factor (4/18/2009)
Paul, Jeff,
I hate to disagree, but distributing a CLR this way is safe as long as you can read any current .NET language to check what is going...
--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)

April 18, 2009 at 3:18 pm

#980258
RE: Are the posted questions getting worse?

Steve Jones - Editor (4/18/2009)
It's not advertising as I'd normally see it. It's a mention that his product, which shall not be mentioned, and which apparently isn't in use 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)

April 18, 2009 at 12:16 pm

#980239
RE: There Must Be 15 Ways To Lose Your Cursors... part 1, Introduction

I agree with that and with what Joe said. That's why I think article's like Barry's series are so important.
--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)

April 18, 2009 at 11:15 am

#980231
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Paul White (4/18/2009)
Jeff Moden (4/17/2009)
Then learn something new, Steve. Learn to make a point without displaying a condescending and arrogant attitude and without words that drip with sarcasm. ...
--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)

April 18, 2009 at 11:04 am

#980225
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Paul White (4/18/2009)
Beware the risk of coming off as arrogant, condescending, and sarcastic...:laugh:
Oh... unlike some on this thread, I'm well aware of those risks. But, I'm also human... I...
--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)

April 18, 2009 at 11:02 am

#980224
RE: Are the posted questions getting worse?

Alvin Ramard (4/17/2009)
Jeff Moden (4/17/2009)
The only sign of snow here in Michigan today is the snow jobs I've been getting from management for the last 2 days.... about 30 feet...
--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)

April 18, 2009 at 9:44 am

#980210
RE: Performance issue with tally solution

Paul White (4/18/2009)
Hey Jeff,
Well that makes sense!
I would just add though that compiled code marked SAFE (as mine was) cannot access external resources:
BOL
Only internal computation and local data access 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)

April 18, 2009 at 9:36 am

#980209
RE: Performance issue with tally solution

Paul White (4/18/2009)
Jeff Moden (4/17/2009)
I won't be able to test the CLR methods on my machine to compare apples with apples.
Why not Jeff? You don't need to compile any...
--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)

April 18, 2009 at 8:52 am

#980186
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

Charles Kincaid (4/17/2009)
Jeff Moden (4/13/2009)
Paul White (4/13/2009)
Jeff Moden (4/12/2009)
Oh, and have you enabled CLR yet and learnt C#? :laugh:
Heh... no, not yet, Paul.
And why should you? We should all...
--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)

April 17, 2009 at 10:26 pm

#980122

Viewing 15 posts - 44,131 through 44,145 (of 59,101 total)