Jeff Moden

Forum Replies Created

Viewing 15 posts - 43,816 through 43,830 (of 59,101 total)

RE: Where Do You Search for DBA Jobs?

nicholasblethyn (5/11/2009)
Serendipity.
The recruiter's best friend has just been launched ...
http://www.telegraph.co.uk/finance/newsbysector/retailandconsumer/5297646/Trevor-Bish-Joness-click-and-mix-approach-to-recruitment.html
Heh... if the automatch requirements that people end up putting into the system are anything like the job requirements I've seen...
--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)

May 11, 2009 at 6:09 am

#992024
RE: UPDATE column with auto number depending on field value ?!

Oh yeah... there's one other thing. You were told a long time ago that you simply can't guarantee the correct order for this type of update unless you have...
--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)

May 11, 2009 at 5:56 am

#992020
RE: UPDATE column with auto number depending on field value ?!

m.berggren (5/11/2009)
Hi,
This works perfekt. I´m thinking of maybe making this more dynamic in some way. Let´s say you don´t know how many "cat" youré having. Let´s say you have 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)

May 11, 2009 at 5:47 am

#992016
RE: Performance issue with tally solution

UMG Developer (5/11/2009)
I'm not a bulk import expert because pretty much all of my data starts in a DB, I took a quick look at BCP, and it didn't seem...
--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)

May 11, 2009 at 5:39 am

#992013
RE: Matrix multiplication without cursors?

In fact... here's a couple of other views concerning world wide browser usage...
http://www.thecounter.com/stats/2009/March/browser.php
http://www.upsdell.com/BrowserNews/stat.htm
http://en.wikipedia.org/wiki/Usage_share_of_web_browsers#Present_to_1999
--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)

May 10, 2009 at 7:48 pm

#991876
RE: Performance issue with tally solution

Phil Factor (5/10/2009)
Jeff Moden
Any word on this, Phil? Copying code from the code windows makes some really ugly stuff with extra line breaks, no indentation, and all those nasty things...
--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)

May 10, 2009 at 7:20 pm

#991874
RE: Matrix multiplication without cursors?

Heh... "Must look eye". That's just for the people that hit the W3Schools website... not what the rest of the world is
doing. Even W3Schools acknowledges that when they included...
--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)

May 10, 2009 at 7:01 pm

#991872
RE: Performance issue with tally solution

UMG Developer (5/10/2009)
I've never heard the phrase to "pork chop" someone what does it mean?
There's a pretty long story behind it, but it basically means taking the person responsible 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)

May 10, 2009 at 6:49 pm

#991871
RE: Performance issue with tally solution

Florian Reischl (5/10/2009)
Hi Jeff
I saw your question and you are correct. If the data are imported by a file this would be the best approach.
But I already started with my...
--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)

May 10, 2009 at 6:35 pm

#991868
RE: Are the posted questions getting worse?

Jeff Moden (5/10/2009)
RBarryYoung (5/10/2009)
Not as I recall. My recollection is that we came up with an alternate way to do it.
Other than using Maxdop, I don't remember coming up...
--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)

May 10, 2009 at 5:20 pm

#991861
RE: Are the posted questions getting worse?

RBarryYoung (5/10/2009)
Not as I recall. My recollection is that we came up with an alternate way to do it.
Other than using Maxdop, I don't remember coming up with an...
--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)

May 10, 2009 at 4:13 pm

#991849
RE: Performance issue with tally solution

I was kind of hoping the data was being imported from a file and that each comment, despite the number of whole and partial lines it may occupy, would have...
--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)

May 10, 2009 at 4:06 pm

#991846
RE: There Must Be 15 Ways To Lose Your Cursors… Part 2: Just Put It in a S

Very cool. Thanks for the feedback, Manie.
--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)

May 10, 2009 at 3:31 pm

#991840
RE: Performance issue with tally solution

UMG Developer (5/10/2009)
Jeff Moden (5/10/2009)
I'm confused... why would you put over 4 million comments together only to break them apart again?
Because in the source data an individual line may be...
--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)

May 10, 2009 at 3:29 pm

#991839
RE: Matrix multiplication without cursors?

Heh... There're a lot of folks that really only have one option for a browser. And, as far as I know, there are still more people in the world...
--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)

May 10, 2009 at 3:04 pm

#991836

Viewing 15 posts - 43,816 through 43,830 (of 59,101 total)