Jeff Moden

Forum Replies Created

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

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
RE: Cross Tabs and Pivots, Part 1 – Converting Rows to Columns

steve dassin (4/17/2009)
I agree. Learning something new is just a form of grandstanding. It's a crutch for people who really haven't mastered what their already using 🙂
Then learn something new,...
--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:08 pm

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

Mike C (4/17/2009)
RBarryYoung (4/17/2009)
The irony here, of course, is that the thing that some readers found most objectionable was that I said that sometimes developers don't care about the quality...
--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 9:38 pm

#980117
RE: Performance issue with tally solution

Florian Reischl (4/17/2009)
Hi Jeff!
Some intermediate results of my current tests. Some new CLR functions joined the competition ;-).
Very cool, Flo. I do have a couple of concerns. Since...
--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 7:51 pm

#980098
RE: Performance issue with tally solution

Paul White (4/17/2009)
It is nice to see that RBAR operations (in the CLR) are now faster than all set based operations.*
* - Do not feel the obvious troll 😛
Why not?...
--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 1:39 pm

#979945

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