Jeff Moden

Forum Replies Created

Viewing 15 posts - 44,116 through 44,130 (of 59,097 total)

RE: TSQL->C# SP

RBarryYoung (4/19/2009)
Paul White (4/19/2009)
RBarryYoung (4/19/2009)
Heh, thanks.
It's just occurred to me that there was a great opportunity back there for you to use a line like:
"I find your lack of faith...
--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 20, 2009 at 5:30 am

#980616
RE: The T-SQL Paradigm

Not necessary is wording fix only... look eye, you must.
--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 8:12 pm

#980483
RE: Performance issue with tally solution

Just curious.... lot's of folks call what's stored in VarBinary, well... Binary and it's actually displayed as hex. So, pardon my ignorance of which you speak, but could you...
--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 7:23 pm

#980473
RE: The T-SQL Paradigm

Paul White (4/19/2009)
Lynn Pettis (4/19/2009)
With the hyperbola and attacks on SQL Server
I apologise profusely in advance, but:
Hyperbola
Hyperbole
My only excuse is that my English teacher was very strict, and it's stuck...
--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 7:15 pm

#980472
RE: The T-SQL Paradigm

Paul White (4/19/2009)
The link doesn't work, Paul.
--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 7:07 pm

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

Paul White (4/19/2009)
Jeff Moden (4/19/2009)
That would be part of the problem.
I quote "you owe me a new monitor!" :laugh:
Heh... call Grant... I understand that he actually keeps spares now.
--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 6:58 pm

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

Paul White (4/18/2009)
Steve,
We should start a new thread for the discussion of table 'variables'.
I want to respond, but this thread is for discussion of Jeff's article on cross-tabs and pivots.
Cheers,
Paul
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)

April 19, 2009 at 6:57 pm

#980467
RE: TSQL->C# SP

Paul White (4/19/2009)
As far as CLR usefulness is concerned, my position is that the overhead (switching languages and IDEs for a start!) means that I always but always 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)

April 19, 2009 at 6:37 pm

#980462
RE: The T-SQL Paradigm

steve dassin (4/19/2009)
And there's nothing cheap in the ideas I'm trying to convey.
That's the point I've been trying to make. Some of your ideas are great... the manner 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)

April 19, 2009 at 6:29 pm

#980461
RE: TSQL->C# SP

Paul White (4/19/2009)
A parting example. An application currently does its business-logic validation in middle-tier classes, written in a variety of .NET languages, and there is a desire to move...
--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 10:45 am

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

steve dassin (4/18/2009)
Oh Jeff I don't feel I've really been sarcastic in these forums.
That would be part of the problem.
--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:54 am

#980354
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

Viewing 15 posts - 44,116 through 44,130 (of 59,097 total)