Jeff Moden

Forum Replies Created

Viewing 15 posts - 36,241 through 36,255 (of 59,067 total)

RE: Are There That Many GUIDs?

Ah... never mind. In a backhanded sort of fashion, I've answered my own question. They do appear to be type 1's based on a statement in the following...
--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)

October 26, 2010 at 11:19 pm

#1242658
RE: Are There That Many GUIDs?

Haven't had the pleasure of working with sequential GUID's in 2k8, yet. You're correct... it's plain to see that they're not type 4's but are you sure they're actually...
--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)

October 26, 2010 at 11:06 pm

#1242656
RE: Are the posted questions getting worse?

Grant Fritchey (10/26/2010)
Jeff Moden (10/26/2010)
Mr. Fritchey... Wow! What a great surprise! I don't deserve it but I'm honored. 🙂
http://www.sqlpass.org/summit/na2010/Agenda/CommunityExpertsPicks.aspx
Don't be. If I end up with only three...
--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)

October 26, 2010 at 7:16 pm

#1242625
RE: Are There That Many GUIDs?

Eric Russell 13013 (10/26/2010)
I'm not intentionally trying to throw gasoline on the fire, but I'd just like to point out that, since a GUID is basically a combination of various...
--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)

October 26, 2010 at 7:00 pm

#1242620
RE: Are the posted questions getting worse?

GSquared (10/26/2010)
Jeff Moden (10/24/2010)
Wow... thanks for the insight on SSIS, folks. I've mostly resisted spending any decent amount of time on it because of what I've seen. 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)

October 26, 2010 at 6:47 pm

#1242619
RE: Are the posted questions getting worse?

Mr. Fritchey... Wow! What a great surprise! I don't deserve it but I'm honored. 🙂
http://www.sqlpass.org/summit/na2010/Agenda/CommunityExpertsPicks.aspx
--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)

October 26, 2010 at 6:31 pm

#1242617
RE: Are There That Many GUIDs?

Paul White NZ (10/25/2010)
Jeff Moden (10/25/2010)
And considering disk storage for the sake of backup time and recovery time isn't something to be horrified by. 😉
We should probably also consider 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)

October 25, 2010 at 10:20 pm

#1242022
RE: Are There That Many GUIDs?

Thomas-282729 (10/25/2010)
Jeff Moden (10/25/2010)
Thomas-282729 (10/25/2010)
It amazes me that top notch developers still try to prematurely optimize.
You and I may be talking about two different things. Doing it right 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)

October 25, 2010 at 7:45 pm

#1242010
RE: Are There That Many GUIDs?

Thomas-282729 (10/25/2010)
It amazes me that top notch developers still try to prematurely optimize.
You and I may be talking about two different things. Doing it right to begin with isn'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)

October 25, 2010 at 6:24 pm

#1242001
RE: replacing long running cursor

Sanjay-940444 (10/22/2010)
Chris, is there any any Microsoft official document which states this?
Jeff, is there a link for what u just mentioned?
Thanks both
I will tell you unequivocally that Microsoft has no...
--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)

October 25, 2010 at 9:52 am

#1241693
RE: Are There That Many GUIDs?

Thomas-282729 (10/24/2010)
1) DISK SPACE isn't what is important, it is THROUGHPUT, and that is dramatically affected by the quadruple-int-sized GUIDs. MEMORY is a precious commodity (on most systems) for the...
--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)

October 25, 2010 at 7:55 am

#1241580
RE: Hierarchy Structure SQL Query

Oh my. KSeet... allow me to apologize for 1.2 million members. You did absolutely everything right in posting table structure, data, desired results, etc, etc, and, still, no...
--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)

October 24, 2010 at 11:39 pm

#1241417
RE: Sequence-numbering groups

Paul White NZ (10/23/2010)
Jeff Moden (10/23/2010)
Do the source (##temp) and destination (##Results) tables need to be global tables in order for the solution that you posted to work?
Hi Jeff,
The most...
--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)

October 24, 2010 at 10:24 pm

#1241405
RE: Sequence-numbering groups

ChrisM@home (10/24/2010)
Jeff Moden (10/22/2010)
... we'll have a drag race. 🙂
Quirky Update would win this one Jeff, by a factor of about 7 - we both know that 🙂
I don'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)

October 24, 2010 at 10:19 pm

#1241404
RE: How to use PIVOT in this case?

WayneS (10/13/2010)
bhushan.bagul (10/13/2010)
thanks for your reply!!!
Glad to be of help. Does it work right for you?
Heh... don'cha just love it?
--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)

October 24, 2010 at 8:00 pm

#1241397

Viewing 15 posts - 36,241 through 36,255 (of 59,067 total)