Jeff Moden

Forum Replies Created

Viewing 15 posts - 41,851 through 41,865 (of 59,067 total)

RE: Help writing a SQL

Man, this is fun to watch... it's a real pleasure to see someone else willing to take on all comers in favor of the "Quirky Update".
Seth, keep 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)

September 20, 2009 at 3:32 pm

#1056062
RE: Are the posted questions getting worse?

Alvin Ramard (9/19/2009)
Jeff Moden (9/19/2009)
I had a peta byte once... Some antibiotics and a tetanus shot took care of the problem. 😛
Jeff, don't you know how to spell?
What you had...
--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)

September 20, 2009 at 3:25 pm

#1056061
RE: find current CPU usage

No... there is no concrete solution because there is no concrete source to the problem. There are many things (usually bad code either from the GUI's or in stored...
--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)

September 19, 2009 at 6:42 pm

#1056014
RE: high CPU usage

chidev (9/18/2009)
It normally takes 5-6 mins for the update stored proc I posted. It took around 45 mins to complete until I started archiving records from a 50 mil...
--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)

September 19, 2009 at 6:30 pm

#1056011
RE: Are the posted questions getting worse?

D.Oc (9/18/2009)
Jeff Moden (9/18/2009)
Paul White (9/18/2009)
¿???p??? o? p??? si?? pui? lli? ????dsi??? u?????ou ??? ?o?? ?ldo?d ?i ??puo? i
Heh... I guess it literally depends on how you look at 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)

September 19, 2009 at 6:21 pm

#1056010
RE: Are the posted questions getting worse?

I had a peta byte once... Some antibiotics and a tetanus shot took care 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)

September 19, 2009 at 6:17 pm

#1056009
RE: selecting specific amount of strings

Well, shoot... I thought you might have been onto something, Dave. I did have to make some very minor changes to your code so it could handle CSV's with...
--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)

September 19, 2009 at 4:31 pm

#1056002
RE: Pulling Filename from Windows directory into table

So far as why the filenames begin duplication at the 256th file, I have no idea. It must be a limit in the sp_AO* sprocs. I can't imagine...
--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)

September 19, 2009 at 2:56 pm

#1055993
RE: Pulling Filename from Windows directory into table

Apologies for the delay. This will do the trick so long as you understand that if MS ever changes the spacing on the output of the DOS DIR command,...
--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)

September 19, 2009 at 2:50 pm

#1055989
RE: Help writing a SQL

Richard Fryar (9/19/2009)
This is only designed for small data sets anyway...
I'm not sure how to say this without someone taking offense, so please take no offense. I know of...
--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)

September 19, 2009 at 2:28 pm

#1055987
RE: Please review BCNF (Put things where it belongs)

David Portas (9/19/2009)
Jeff Moden (9/17/2009)
the surrogate key is the check account number
An account number is not a surrogate key. It's a business key, i.e. it identifies something in the business...
--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)

September 19, 2009 at 2:03 pm

#1055982
RE: Help writing a SQL

Garadin (9/18/2009)
...but it still doesn't even come close to the speed of the update. Even selecting that entire 2 million row dataset into a temp table and running 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)

September 18, 2009 at 9:32 pm

#1055911
RE: Help writing a SQL

Garadin (9/18/2009)
Jeff Moden (9/18/2009)
Turn off the execution plan and see what you get.
Without the execution plan, 12 seconds for quirky with MAXDOP 1, 151 for the RCTE. I ran...
--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)

September 18, 2009 at 9:29 pm

#1055910
RE: Qry Performance

If nothing else, the NOT LIKE will likely force a scan.
--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)

September 18, 2009 at 12:25 pm

#1055796
RE: Parse data colunm into 3 columns

vmon (9/18/2009)
Thanks for replying Jeff. I am not sure how to go about this. The order of data will be constant. The tags will be constant as...
--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)

September 18, 2009 at 12:20 pm

#1055792

Viewing 15 posts - 41,851 through 41,865 (of 59,067 total)