Jeff Moden

Forum Replies Created

Viewing 15 posts - 42,256 through 42,270 (of 59,102 total)

RE: Mark as Answer and Collect Pointers

Ditto to both of those responses. Many times, we can't even get the OP to effectively post the question. Why would you want someone like that to decide...
--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)

August 20, 2009 at 6:48 pm

#1042532
RE: Are the posted questions getting worse?

RBarryYoung (8/20/2009)
FYI, am in the hospital again, back problems (can't walk or even sit up), was admitted through the ER yesterday. as before, if you guys could cover for...
--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)

August 20, 2009 at 12:39 pm

#1042352
RE: Calculations

Your welcome but a word of caution... if a GUI is involved, formatting of this nature should be done in the GUI. And, never store formatted numeric data 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)

August 20, 2009 at 12:03 pm

#1042326
RE: Storing IPv4 Addresses for Performance

TheSQLGuru (8/20/2009)
hey, what about using 32 bit fields??
just kidding
😀
Heh... how about 4 byte ASCII character based? 😛
--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)

August 20, 2009 at 11:02 am

#1042286
RE: Storing IPv4 Addresses for Performance

Very Cool.
--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)

August 20, 2009 at 10:21 am

#1042257
RE: Storing IPv4 Addresses for Performance

Jean-Sebastien Carle (8/20/2009)
I must appologize Jeff, in my haste I misread part of your code. It is indeed an interesting approach that I will explore further.
Very cool. Thank 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)

August 20, 2009 at 10:14 am

#1042249
RE: Storing IPv4 Addresses for Performance

TheSQLGuru (8/20/2009)
Hey Jeff - I gotta ask: do you actually WORK for a living?? Maybe you get paid for what you know and not what you do at...
--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)

August 20, 2009 at 10:13 am

#1042247
RE: Storing IPv4 Addresses for Performance

TheSQLGuru (8/20/2009)
You are correct Jeff - it was a very good article. Much better IMHO than much of what is put out on the web these days.
As for your...
--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)

August 20, 2009 at 9:24 am

#1042205
RE: Storing IPv4 Addresses for Performance

Elliott W (8/20/2009)
Well said Jean-Sebastien, well said.
CEWII
You need to go back and look at my code then. I've not suggested the creation of every possible IP address.... I've suggested...
--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)

August 20, 2009 at 9:20 am

#1042198
RE: Storing IPv4 Addresses for Performance

rja.carnegie (8/20/2009)
I don't rule out the x 10 GBytes lookup table - you probably only need that all online unless you're running the whole Internet, and no one does that...
--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)

August 20, 2009 at 9:17 am

#1042196
RE: Storing IPv4 Addresses for Performance

Jean-Sebastien Carle (8/20/2009)
I've seen a lot of posts regarding the poor performance of UDFs. I believe that's missing the point. Generally speaking, there is no need for displaying 10,000 IPv4...
--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)

August 20, 2009 at 9:14 am

#1042195
RE: selecting specific amount of strings

Dave Ballantyne (8/20/2009)
Select n+1
from nums
where n < datalength(@MyString)
and substring(@MyString,n,1)=' '
...
--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)

August 20, 2009 at 6:26 am

#1042050
RE: Calculations

You can "cheat" a bit on this type of code...
SELECT STR((23-20)*100.0/20,5,1)+'%'
--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)

August 20, 2009 at 6:18 am

#1042047
RE: Interview "Don'ts"

Brandie Tarvin (8/20/2009)
Found this link through Yahoo. It's pretty good stuff. Thought I'd share. Hope it helps someone out.
http://hotjobs.yahoo.com/career-articles-10_ways_to_be_liked_in_your_job_interview-947
Very cool. Thanks, Brandie.
--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)

August 20, 2009 at 6:14 am

#1042045
RE: Storing IPv4 Addresses for Performance

Gosh... I'm really torn here. Jean-Sebastien, you did a heck of a nice job.
I can't take anything away from the author. This is a very well...
--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)

August 20, 2009 at 12:14 am

#1041948

Viewing 15 posts - 42,256 through 42,270 (of 59,102 total)